tags:

views:

273

answers:

0
Q: 

SQL Separate String

Duplicate

Separate String with separator #@#

The string below I have to call three times using sql. String: JAN#@#PIET#@#HENK

The first call shoudl return: JAN The second call: PIET The third: HENK

So we could use the #@# as separator but it could be that the string is: JAN#@#PIET only. Still all three calls will be done where call 1 returns: JAN call 4 returns: PIET cal three return: <>

Same could happen for string JAN only.

I hope this explanation is sufficient for someone to help me with this case.

related questions

Does anyone have a good Proper Case algorithm
Converting bool to text in C++
Does PHP have an equivalent to this type of Python string substitution?
PHP ToString() equivalent
What's the difference between a string constant and a string literal?
What would be the fastest way to remove Newlines from a String in C#?
Why is String.Format static?
PowerShell - How do I pass string parameters correctly?
What's the best string concatenation method using C#?
Java: Best way of converting List<Integer> to List<String>
C# String output: format or concat?
Parse usable Street Address, City, State, Zip from a string
C# Save Dialogs
How do I Convert a string to an enum in C#?
PowerShell - how do I do a string replacement in a function?
Case insensitive string comparison in C++
Why doesn't Ruby have a real StringBuffer or StringIO?
Checking for string contents? string Length Vs Empty String
Remove Quotes and Commas from a String in MySQL
Test serialization encoding
In C# what is the difference between String and string
String.indexOf function in C
What is the best way to parse strings in Java
Format string to title case
Generate list of all possible permutations of a string