Hi all,
If I have a string like this, 1-2-3,
how do I get the 2 using SQL query?
The number of digits between the '-' can be more than one and also it can be a letter instead of number.
For example, I want to do something like "SELECT [this] FROM [table]". I want to know what to put in '[this]' so that I can get the center one between the dash.
Anyone can help? Thanks!
Using your example, try SELECT SUBSTRING('1-2-3', 3, 1)or to select from a table, try the following syntax:
SELECT SUBSTRING(colname, start, length) FROM tablename