It appears that surnames are to be required in future versions, I am wondering what will happen to all the characters with singular names now? Will they be changed willy-nilly, will they be left as is until the eventual wipe, will the gms be forced to work overtime changing as many as possible for a period after which it will revert to option one?
set @racetype as varchar(15)
begin tran
update [name of table] set [name of character last name field] = @racetype in (select case [race type identifier field]
when [identifier for enki race type] then "Enkidukai"
when [identifier for Ylian race type] then "Ylian"
when [identifier for Xacha race type] then [ "Xacha"
when [identifier for Nolthrir race type] then "Nolthrir"
when [identifier for Dermorian race type] then Dermorian
when [identifier for Stonebreaker race type] then "Stonebreaker"
when [identifier for Hammerwielder race type] then "Hammerwielder"
when [identifier for Lemur race type] then "Lemur"
when [identifier for Kran race type] then "Kran"
when [identifier for Diaboli race type] then "Diaboli"
when [identifier for Klyros race type] then "Klyros"
when [identifier for Ynnwn race type] then "Ynnwn"
end)
where [name of character last name field] = NULL
--commit --rollback
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
more or less i think thats the proper syntax.
Edit: realised there is a logic flaw in that statement and corrected it

(added a where clause)