LenTompkins
asked on
INSERT DASHES INTO A STRING
i NEED TO INSERT DASHES INTO A STRING OF 11 CHARACTERS XXXXX-XXXX-XX in SQL Server 2005
I can extract the left 5 and concatenate the dash, using Left(column name,5) and the same thing for the last two positions with Right, but how do I obtain the middle four? I didn't see a mid function as there is in Access.
Thanks for your assistance
I can extract the left 5 and concatenate the dash, using Left(column name,5) and the same thing for the last two positions with Right, but how do I obtain the middle four? I didn't see a mid function as there is in Access.
Thanks for your assistance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER