CREATE TABLE Students (fullname VARCHAR(20) PRIMARY KEY)

INSERT INTO Students VALUES ('Bill Clinton')
INSERT INTO Students VALUES ('George W. Bush')
INSERT INTO Students VALUES ('Smith')

SELECT LTRIM(RIGHT(fullname,CHARINDEX(' ',REVERSE(' '+fullname)))) AS
lastname
FROM Students

--
David Portas
------------
Please reply only to the newsgroup
--