-
Datasource Problem
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