Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
STRTRAN() & Null as Replacement
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7 SP1
Divers
Thread ID:
01471525
Message ID:
01471531
Vues:
69
>>Is the following a bug in STRTRAN()? It happens in VFP 7 & 9.
>>
>>? ISNULL(STRTRAN('XXX', 'YYY', NULL)) && prints .T.
>>
>>'YYY' doesn't appear in 'XXX', so why is it substituting NULL in the first place? If the expression sought doesn't exist in the expression to be searched, I would expect to have the expression to be searched returned as is, regardless of the replacement expression.
>
>Looks like you found a bug! I also would expect this to return 'XXX' instead.

Hmm, when you work with NULLs you never know what you should expect. And in most cases you should expect NULL as a result :-)
Here a simple SQL Server T-SQL that returns the same (NULL):
declare @Test varchar(200)
SET @Test = 'YYY'
SELECT REPLACE(@test,'XXX',NULL)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform