Kbase P113959: How to split a field into two fields with a space between them in SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/3/2006 |
|
Status: Unverified
GOAL:
How to split a field into two fields with a space between them in SQL-92?
FIX:
The syntax shown below shows how to take a character field, split it into two substrings and concatenate them back together with a single space added between the two substrings:
SELECT CONCAT(CONCAT(SUBSTR(YourField,1,10),' '),SUBSTR(YourField,11)) FROM YourTable