search for special sentence in a whole string?

[Assaf82]

If i want to search for sentence in a whole string how i can do? Ex: str ="SELECT Currency.CurrCode, Currency.CurrName FROM CurRate INNER JOIN Currency ON CurRate.Code = Currency.CurrCode" I want to check if CurrCode exist or not ? and how to check from the case sensitive Thanks a lot

Assaf

[leoiser]

There are few methods to case sensative searches convert or cast the search field to varbinary Decalre @Code varchar(50) set @Code = 'A22' SELECT Currency.CurrCode, Currency.CurrName FROM CurRate INNER JOIN Currency ON CurRate.Code = Currency.CurrCode where CAST(CurRate.Code as varbinary(50)) = CAST(@Code as varbinary(50)) points to note:- @Code type & size (here varchar(50) should be same as CurRate.Code Hope this will solve your issue. Thanks

[Guffa]

Use the IndexOf method of the string class. There are overloads where you specify a StringComparison value that determines how the comparison is done.

--- single minded; short sighted; long gone;