> 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.
With SQL Server you can use PATINDEX or CHARINDEX to
locate the position in a string where one or more characters are.
Documentation can be found in Books Online.
Stephen
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
