Hi guys

i did that paul and this is the responce in sql anaylizer

Server: Msg 207, Level 16, State 3, Line 1

Invalid column name '%'.

Server: Msg 207, Level 16, State 1,...

Thanks Sushila

But no, the string is not friday

the string i am passing in is 'i was born on Friday afternoon'

so i want to pull the record that matches friday

so a...

Hi Paul

Thank you for you reply, I have tried that and it doesnt work

here is the problem

the string i have has a load of stuff it in...