Mike & Doris Manning
mikedorism at verizon.net
Tue Aug 23 08:40:09 CDT 2005
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. Doris Manning mikedorism at verizon.net -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jonathan Guise Sent: Tuesday, August 23, 2005 9:28 AM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [dba-SQLServer] InStr equivalent Yes there is a SQL server equivalent called substring: substring(<colname>,<start>,<Length>) Regards, -----Original Message----- From: Susan Harkins [mailto:ssharkins at bellsouth.net] Sent: 23-Aug-2005 14:19 To: SQLList Subject: [dba-SQLServer] InStr equivalent Does SQL Server have a string function that's similar to Access's InStr() -- I haven't found one. Susan H. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com