or

select SURNAME || ', ' || FIRSTNAME as Name from CS_STAFF

if u want to give the column a name called "Name"

ohh what a dummy! I realise my mistake..instead of " i should have used 'so that is looks like the following:

select SURNAME || ', ' || FIRSTNAME from CS_STAFF

thanks for...