Constructing an sql string

[davebat]

Hi, Im trying to build some sql through string concatenation can someone take a look, im having problems with quotes.

set @SQL = @SQL + 'CASE owner_ein '
set @SQL = @SQL + 'WHEN ''NA'' THEN ''Unassigned'' '
set @SQL = @SQL + 'else ''''<a target=''_blank'' href=''http://url?ein='' + ein + ''''>'' + LEFT(firstname, 1) + ''. '' + surname + ''</a>'' AS name''' 
set @SQL = @SQL + 'END as name '

Its the third line im having trouble with.

[Asgorath]

Hi
I have copy and pasted query into Query Analiser for ms sql 2000 and no errors.

[davebat]

thanks, but there were errors when calling the stored procedure from the web. I have sorted it now anyway, if anyones interested.

set @SQL = @SQL + 'else ''<a target="_blank" href="url?ein='' + ein + ''">'' + LEFT(firstname, 1) + ''. '' + surname + ''</a>'''

i didn't know you could use " in the string