But what happens when the somebody named Bob Van Smith (last name is Van
Smith) gets added to your database?
Kyle M. Burns, MCSD, MCT
ECommerce Technology Manager
Centra Credit Union
>> -----Original Message-----
>> From: henryh@p... [mailto:henryh@p...]
>> Sent: Thursday, February 28, 2002 1:53 PM
>> To: sql language
>> Subject: [sql_language] Parsing Names
>> OK here is the deal
>> I have a field called NAME
>> it contains "BOB JOE SMITH" or "BOB SMITH"
>> I need to know a script to go from the end of the name and
>> go backwards to
>> get the last name out of it
>> Like to pull out "SMITH"
>> I can pull first name and I can pull middle and last
>> together but i can't
>> get it to skip from the end to the front.
>> ANY HELP WOULD BE GREAT.