I want to store a position of index in a variable using SQl query But not with stored procedure. Like this select set i=charindex("DAY","Docterms")(case when i<>0 then ' ' else ' ' end)from table. I also want to do Microsoft certified course can anyone tell me about online certofication related to DBA administrator or SQL Expert.
