Hi,

I have a task to write a searching program to get the records which doesn't march the condition.

for example, my table like this
ID column1 cloumn2
01 TEST this is a test program
02 hello hello,everyone
03 bye goodbye

according to the column1 ,searching cloumn2 word by word. but it has to be from the very first of the word. such as 01,02 is right. but 03 is wrong. cause "bye" is not the first three letters of this word.

Can I use patindex to do it? how to use it?

thanks!