Link to home
Start Free TrialLog in
Avatar of LenTompkins
LenTompkinsFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of UnifiedIS
UnifiedIS

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LenTompkins

ASKER

I split the points because you both wrote your answers at about the same time.  That worked great.