ALLTRIM syntax not support with SQL Server

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

ALLTRIM syntax not support with SQL Server

Message

10/04/2003 09:05:03

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

10/04/2003 09:01:17

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Client/serveur

Titre:

Re: ALLTRIM syntax not support with SQL Server

Divers

Thread ID:

00775890

Message ID:

00775986

Vues:

>I doesn't generate extra spaces in VFP8 for me.

I have it all the time. The following, either from a datetime or date field, generates some extra spaces between the 4 digits of the date and the letter A when being printed:

SELECT LTRIM(RTRIM(STR(YEAR(AddDate)))) AS lcChampNumero FROM News
? lcChampNumero+'A'

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

Répondre

Fil

Voir

Click here to load this message in the networking platform