Equivalent of "Startswith", "Endswith", "Contains" string comparisons in t-sql?

[Robin Tucker]

Hi,

I would like to select records from a table where the following criteria
hold:

SELECT * from Mytable where

field x "contains" string @X

or

field x "starts with" string @X

or

field x "ends with" string @X

What would the syntax for the "LIKE" predicate be in each of these
instances?
Thanks.

[Robin Tucker]

I got it:

startswith: WHERE x LIKE @Value + '%'

endswith: WHERE x LIKE '%' + @Value

contains: WHERE x LIKE '%' + @Value + '%'

"Robin Tucker" <id*************************@reallyidont.com> wrote in
message news:c7*******************@news.demon.co.uk...

Hi,

I would like to select records from a table where the following criteria
hold:

SELECT * from Mytable where

field x "contains" string @X

or

field x "starts with" string @X

or

field x "ends with" string @X

What would the syntax for the "LIKE" predicate be in each of these
instances?
Thanks.