i want to create a stored procedure that can return the initial character of two string inside the description field.
ex. Computer Security -> in one data only
if i use this statement
select left(description) from table1
i want to return only CS when i run my script.
is there a way to do this?