PATINDEX ( '%pattern%' , _expression_ )
Check SQL Server BOL for more info on how to use these functions.
-----Original Message-----
From: Lee [mailto:[EMAIL PROTECTED]
Sent: Monday, August 02, 2004 3: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]
