Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How To Code These Requirements
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
How To Code These Requirements
Divers
Thread ID:
01425624
Message ID:
01425624
Vues:
100
1) If CUS_CorpAddress contains linefeed characters, then take the string up to the first linefeed, else take the entire string. In either case, do not take more than 30 characters.

2) If CUS_CorpAddress does not contain linefeed characters, then " ". Else if CUS_CorpAddress contains at least two linefeed characters, then take the string from the first to the second linefeed, else take the string from the first linefeed to the end. In any case, do not take more than 30 characters.

3) If CUS_CorpAddress contains less than two linefeed characters, than " ". Else if CUS_CorpAddress contains at least three linefeed characters, then take the string from the second to the third linefeed, else take the string from the second linefeed to the end. In any case, do not take more than 30 characters.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform