SQLSERVER2000
----------------------

Dear All,


I want to update to a table field. I use
Query= 'Select 'c' distinct S.Name'.

i want to enter a varchar value like that having 'c' inside but sqlserver give me an error.

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'c'.



update AllQueryFields set Query= 'Select 'c' distinct S.Name '
Where ObjectName ='0303' and FieldAlias='Status'


how i can enter that value