character search

[sp1502]

is there any way in sql to search for a particular sequence of characters in a field regardless of position. For
example the word "PAY" in field "OTPAY1234".

Thanks in advance.

 

[karluk]

select col_name from your table
where col_name like '%PAY%'

 

[sp1502]

THANKS karluk ,it worked