Invalid column name error when passing Name parameter

[amber]

HI  I am trying to pass parameter first_name and when i pass in query and create parameter then this shows error

this is the query which used 

and this is the error i receive

whereas when i use this query for  Customer_ID parameter this works but not works with Name.. where is the mistake? why not working with Name

[JWiseman]

Hi Amber, in the Command query WHERE clause try putting the First_Name@ prompt in single quotes. Otherwise it's assumed that the first name parameter value is a field name.

i.e. cs.First_Name = '{?First_Name@}'

[amber]

Thanku so much . It works 🙂