Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Code These Requirements
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
How To Code These Requirements
Miscellaneous
Thread ID:
01425624
Message ID:
01425624
Views:
101
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
Next
Reply
Map
View

Click here to load this message in the networking platform