[dba-SQLServer] SQL in SP failing

Hello All,

Any idea why the following SQL will fail in an SP?

'insert into tblBrita_ID(case_id,Criteria) SELECT case_id, "test" As 
Criteria FROM tblCase where case_id=1'

The error is "Invalid column name 'test'."  It doesn't always 
fail...normally 'test' is a parameter passed to the SP...I have modified it 
to the above for demo purposes...but using just the word 'test' as above 
still gives the same error.

Thanks,

Mark A. Matte

_________________________________________________________________
Get the latest Windows Live Messenger 8.1 Beta version. Join now. 
http://ideas.live.com