PADL() equivalent in SQL Server - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

PADL() equivalent in SQL Server

Message

De

10/04/2003 11:16:10

Michel Fournier
Level Extreme Inc.
Petit-Rocher, Nouveau-Brunswick, Canada

À

10/04/2003 11:12:49

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Client/serveur

Titre:

Re: PADL() equivalent in SQL Server

Divers

Thread ID:

00776019

Message ID:

00776097

Vues:

34

>Try to cust it to character type

SELECT CAST(REPLACE(STR(MONTH(AddDate),2), ' ', '0') AS char(2))

Same thing

Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52

Click here to load this message in the networking platform