This way I can take impossible-to-sort varchars, and sort them by the converted field instead, making the recordset prettier.<BR><BR>Right now SCNumber might look like the above, '99' implying ...

Finally RIGHT function will generate a string from rightmost side and will get appended to @EmpPrefix from rightmost side. Finally create a stored procedure ‘spEmpDetails_Save’ where 'fnEmpCode' ...