[dba-SQLServer] InStr equivalent

Arthur Fuller artful at rogers.com
Tue Aug 23 11:35:51 CDT 2005


Look up CharIndex() in BOL.

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: August 23, 2005 9:41 AM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer] InStr equivalent

Right -- I know about Substring -- I need the specific position of the
string as a value -- 

Susan H. 

SubString isn't the same as InStr.  InStr returns the position of the string
being searched for while SubString returns a string in a specific place.


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list