Sql Server Programming :: Find or Search funtion?


	Find or Search funtion? Is there a function I can use to search for a certain string within some text? For example, something like: search("-","1234-5678") would return 5, because the "-" shows up in the 5th position of "1234-5678". Thanks, -- Regards, Dave Look up these functions in Books Online: CHARINDEX PATINDEX -- Aaron Bertrand SQL Server MVP http://www.sqlblog.com/ http://www.aspfaq.com/5006 "David Billigmeier" <dtbil@hotmail.com> wrote in message news:958F5DDB-6A3D-406A-B60C-B67079B40D0E@microsoft.com... - Hide quoted text - > Is there a function I can use to search for a certain string within some > text? For example, something like: > search("-","1234-5678") > would return 5, because the "-" shows up in the 5th position of > "1234-5678". > Thanks, > -- > Regards, > Dave