CHARINDEX: Returns the starting position of the specified _expression_ in
a character string
PATINDEX: Returns the starting position of the first occurrence of a
pattern in a specified _expression_, or zeros if the pattern is not found,
on all valid text and character data types.
STUFF:
Deletes a specified length of characters and inserts another set of
characters at a specified starting point.
-----Original Message-----
From: Lee [mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 4:37 PM
To: CF-Talk
Subject: SQL Find
Does SQL Server have an function similar to CF's "Find"
string function. I need to parse 150,000 names depending on where the
comma is in the string and update each record. Not a great task for CF.
I'm aware of the substring command but it needs to know what position
the comma is in.
Lee Surma
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
