Hi,How to get first character from special characters string.
for ex. i have below string and want to get first word 'Yes' -
~~~~~~~Yes~~~~~~~~No~No~~~~~~~~~
and also another case is , where i want 'Maybe' -
Maybe~~~~~~~~No~No~~~~~~~~~
Is there any approach ? Thanks
HanookPosted Nov 15, 2013, 6:08 AM
Just Keep column name instead of @str and add FROM tableName clause at the end of above query...