How would you turn this around? 1

[Guest_imported]

How would you turn this syntax around to grab the last name from the field vname(name) and populate the last name field(VLNAME)?


UPDATE L3_MASTER_SAMPLE
SET VFNAME =
(
SELECT
SUBSTR(BACKUP.VNAME,1,INSTR(BACKUP.VNAME,' ',-1))
FROM
L3_MASTER_SAMPLE,
BACKUP
WHERE
L3_MASTER_SAMPLE.ID = BACKUP.ID

)

 

[Jerrycurl]

Since Instr is not a SQL Server function you have to use Charindex instead.

UPDATE L3_MASTER_SAMPLE
SET VLNAME =
(
SELECT
RIGHT(BACKUP.VNAME,CHARINDEX(' ',BACKUP.VNAME,0))
FROM
L3_MASTER_SAMPLE,
BACKUP
WHERE
L3_MASTER_SAMPLE.ID = BACKUP.ID

)