How to Split String by Character into Separate Columns in SQL Server

by

There are probably several different ways to do it, some uglier than others. Here’s one:

(Note: dat = the string of characters)

select *,
  substring(dat,1,charindex('-',dat)-1) as Section,
  substring(dat,charindex('-',dat)+1,charindex('-',dat)-1) as TownShip,
  reverse(substring(reverse(dat),0,charindex('-',reverse(dat)))) as myRange
from myTable

More Related Contents:

  1. Difference between LIKE and ~ in Postgres
  2. Calculating distance between two points (Latitude, Longitude)
  3. T-SQL split string based on delimiter
  4. WHERE Clause vs ON when using JOIN
  5. REGEX to select nth value from a list, allowing for nulls
  6. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  7. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  8. CASE WHEN statement for ORDER BY clause
  9. How to get last 7 days data from current datetime to last 7 days in sql server
  10. Varchar variable is not working in WHERE clause
  11. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  12. Reference an alias elsewhere in the SELECT list
  13. Count Returning blank instead of 0
  14. oracle — Split multiple comma separated values in oracle table to multiple rows
  15. Regular Expressions in DB2 SQL
  16. Regular expression in PostgreSQL LIKE clause
  17. Regular expression to match common SQL syntax?
  18. Using IF ELSE statement based on Count to execute different Insert statements
  19. How to find out what is locking my tables?
  20. Passing dynamic order by in stored procedure
  21. Perform regex (replace) in an SQL query
  22. Select SQL Server database size
  23. Check if table exists and if it doesn’t exist, create it in SQL Server 2008
  24. How do I find the data directory for a SQL Server instance?
  25. How to return default value from SQL query
  26. MSSQL Regular expression
  27. How to concatenate all columns in a select with SQL Server
  28. RegEx to Detect SQL Injection
  29. T-SQL calculate moving average
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment