I have a table called CUSTTABLE within a database with two columns called cust_name (to hold their names) and cust_number (to hold their number) . both these columns have been populated and am trying to read data from here. cust_name has data type(Varchar(50) while cust_number has data type numeric (18,0) I am trying to display both customer's name and number by using their name
>>> select * from CUSTTABLE where cust_name = 'smith' <<<<<
this syntax doesn't work and brings up the error Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'smith'.
when I changed over and search using their number it works and brings the right results. here is the syntax that works
select * from CUSTTABLE where cust_number = '077885421'
can anyone please advise on where am going wrong