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