name trimming--help!!

[Mbroad]

Hi--I have a 36 character NAME field on TABLE-1 (containing first and last name)

I need to separate the first-name & last-name from NAME writing them to TABLE-2 FNAME and LNAME fields

the "sticking "point is that I can only use the first 15 characters of each first or last name

I am not sure how or IF this can be done.
Please advise,
thanks,
Mark

Government Coder Mark

 

[mrdenny]

Use CHARINDEX and SUBSTRING to split the field appart (there are several examples in the forums on this). Then use LEFT (or SUBSTRING again) to ensure that the names are only 15 characters max.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SQLDenis]

declare @name varchar(49)
select @name ='Williamus12345678 Gatessususonus12345678'
select left(PARSENAME(REPLACE(@name,' ','.'),2),15) as FirstName,
left(PARSENAME(REPLACE(@name,' ','.'),1),15) as LastName

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/