Add prefix '0' to the column value

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Add prefix '0' to the column value

Message

30/09/2017 23:46:15

29/09/2017 12:30:19

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Divers

Thread ID:

01654668

Message ID:

01654699

Vues:

>
>How do I do it in T-SQL in one UPDATE?
>
>TIA

There might be more recent ways to do this, but here's how I always do it...

UPDATE TestTable SET TestColumn = RIGHT('0000' + TestColumn,4)