Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

SQL Server Spaces within a string

Anonymous User 1919 06 Nov 2014

I need to add spaces within a string.

Original String: up70aert55
Expected Result: up 70 aert 55

1 Answers

Takeshi Okada 06 Nov 2014

can achieve this with LEFT, SUBSTRING, RIGHT functions.

SELECT LEFT('up70aert55',2)+' '+
SUBSTRING('up70aert55',3,2)+' '+
SUBSTRING('up70aert55',5,4)+' '+
RIGHT('up70aert55',2);

MindStick Training

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.