如何使用CONTAINS进行SQL部分搜索

I'm new to SQL and I'm trying to perform a partial search using CONTAINS which uses a variable. It works fine when looking for a "complete" term but not partial. Let's say there's a row with the entry "Tristan" nothing pops up when I'm using just "Trist". I tried to do this: I'm new to SQL and I'm trying to perform a part