Information générale
Catégorie:
Codage, syntaxe et commandes
>>
>>That's because "-" trims trailing spaces. Try
>
>Is this correct? I thought "-" moved the spaces to the end rather than trimming them.
>
>
>
>>
>>lastName - ", " + firstName
(or RTRIM(firstName)
)
>>
>
>If LastName has trailing blanks I got
>LLLLLL, FFFFFF
I'm virtually ignorant of HTML and didn't realize the extra blanks would get trimmed out of my reply. It should have been
LLLLLL,BBBBBBFFFFFF
where "B" represents a blank
>
>
>>or, to be more elaborate,
>>
>>ALLTRIM(lastName) + ", " + ALLTRIM(firstName)
>
>This looks like the best bet
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement