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
kburns@c...

 

>> -----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. 
>> 
>> 
>> Thanks 
>> 
>> Henry
>> $subst('Email.Unsub').
>>