We have a table which stores the FullNames of all users. I would like to get the first character of the FIRST NAME and all characters of the Last Name. There is a space between both those names.
The best thing is to first analyse how all patterns can come and then formulating a rule for each. Might have to apply separate logic for each set to get intended result
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
SQL Query ?
Posted - 12/12/2012 : 11:24:27
