Hello Experts,

i have a sql command like 'Select Empcode, Empname from employee where empcode = '001' into cursor cur1'

Sele Cur1
cName = Cur1.Empname

in Visual foxpro, But i want to execute the Same command from Sql Stored Procedure how will do this? And if employee code is not found i want to show the appropriate massage like 'Inavlid code'.
Please i need someones kind help.......................

Regards
Abdulla