Just to add to that, you will need to escape the singal quote, with a single quote.
e.g.
declare @statement varchar(100)
set @statement = 'select ''DAY NO.: '' + CAST(DATEPART(DAY,getdate()) AS VARCHAR(2))'
execUTE( @statement)
where you to write the actual sql it would be:
select 'DAY NO.: ' + CAST(DATEPART(DAY,getdate()) AS VARCHAR(2))
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)