Hi,

I am trying to enter an SQL string into a function for my ASP page which works fine (see below):

Datasource='<%# Getdataset("Select Player_id,Player_Forename + Player_Surname as Player_Name from tblplayer",DSplayer_ID) %>'

However what I want is to have a space between Player_Forename and Player_Surname, normally in SQL I'd just write + ' ' + but this doesn't work and neither does + " " +. I'm sure this is probably a really simple problem but does anyone know what the correct syntax is?

Cheers,

Vidal