How to use patindex
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?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL