- How can I return a substring based on CharIndex for starting and end points from a field in a table?
- SELECT SUBSTRING(ColName, CHARINDEX('TxTStart', ColName), CHARINDEX('TxTEnd', ColName))
- FROM htmlTable ht
- WHERE ht.Date_ = '2009-01-01'
- SELECT SUBSTRING(ColName, CHARINDEX('TxTStart', ColName), CHARINDEX('TxTEnd', ColName) - CHARINDEX('TxTStart', ColName))
- FROM htmlTable ht
- WHERE ht.Date_ = '2009-01-01'
Don't like ads? PRO users don't see any ads ;-)
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
create a new version of this paste
RAW Paste Data