Normalizing in SQL with various character length

Asked Aug 31 '16 at 12:27

Active Aug 31 '16 at 12:39

Viewed 56 times

I am trying to normalize a field in SQL.

Example:

HXDF469LDI

HXDF469801LDI

This is missing the preceding zeros before the 469.

It should be HXDF000469LDI or HXDF000469801LDI.

The preceding zeros can vary from 1-5 zeros missing. There should be six numbers after the HXDF but because some also contain an extension of 801, 802 and etc not sure how to do this.

edited Aug 31 '16 at 12:34

tgolisch

6,549
3
24
42

asked Aug 31 '16 at 12:27

Veronica

Which DBMS are you using? – Aug 31 '16 at 12:38
not clear what you are looking for.. You wanted to get the column data in a unique way or you wanted to update the existing data? – Unnikrishnan R Aug 31 '16 at 12:39
I am using Teradata but I can also use SQL Server if need be. – Veronica Sep 01 '16 at 05:13

Normalizing in SQL with various character length

0 Answers0