Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

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...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc