Newbie Question

Hi all,

I am using following update command but getting error on database field
name. I can't change the database filed name, please give me idea how can
I use reserved word in this statement.

update ws_apps
set database = 'EFORMS'
where app_id=4

Thanks for your helphqureshi1103@.rogers.com (Adnan Jamil) wrote:
>Hi all,
>I am using following update command but getting error on database field
>name. I can't change the database filed name, please give me idea how can
>I use reserved word in this statement.
>update ws_apps
>set database = 'EFORMS'
>where app_id=4
Try:
update ws_apps
set [database] = 'EFORMS'
where app_id=4

HTH,
Myron