T-SQL Split Word into characters

by

Do it like this:

select substring(a.b, v.number+1, 1) 
from (select 'QWERTY AnotherWord' b) a
join master..spt_values v on v.number < len(a.b)
where v.type="P"

More Related Contents:

  1. Is there a function to split a string in PL/SQL?
  2. How to split a string into substrings of a given length? [duplicate]
  3. Does xslt have split() function?
  4. Integer PadLeft function in T-SQL
  5. Is there a function to split a string in Oracle PL/SQL?
  6. scala string.split does not work
  7. How to split a string by a string in Scala
  8. Splitting a string at every n-th character
  9. Convert Int to String in Swift
  10. PHP: Split string [duplicate]
  11. How do I remove the file suffix and path portion from a path string in Bash?
  12. How to split strings into text and number?
  13. Better techniques for trimming leading zeros in SQL Server?
  14. How to split one string into multiple strings separated by at least one space in bash shell?
  15. In Perl, how can I read an entire file into a string?
  16. Split a string with delimiters but keep the delimiters in the result in C#
  17. Extracting pairs of words using String.split()
  18. Java String.split() Regex
  19. How to concatenate strings with padding in sqlite
  20. Java: String split(): I want it to include the empty strings at the end [duplicate]
  21. How to make my split work only on one real line and be capable to skip quoted parts of string?
  22. Assembly x86 Date to Number – Breaking a string into smaller sections
  23. When using the MOV mnemonic to load/copy a string to a memory register in MASM, are the characters stored in reverse order?
  24. String attribute values in multiple lines, HTML
  25. Get values between curly braces c#
  26. Excel VBA like operator [closed]
  27. How can I replace newline characters using JSP and JSTL?
  28. Remove all line breaks at the beginning of a string in Swift
  29. How to count the number of lines of a string in javascript
  30. Java replace all square brackets in a string

Leave a Comment