why this query throws an error ?

navedjobs · #1 (**permalink**) 12-04-11, 01:15

Code:

select * from emp_info where emp_id = 66

gives me blank rows because there is no record for this emp_id
but when i do something like this

Code:

select * from emp_info where emp_id = e3

why this throws an error ? saying

Code:

Msg 207, Level 16, State 1, Line 1
Invalid column name 'e3'.

r937 · #2 (**permalink**) 12-04-11, 04:18

you forgot the quotes which are needed to delimit a string

Code:

select * from emp_info where emp_id = 'e3'