Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Extracting a string using Regular Expression
Is there a function to extract part of a string using a regular expression? Seems such a simple thing, but I don't seem to be able to find it anywhere. Not too keen on using substring, unless there is a good way of applying it. It would be something like this (where "REGEX" is a function that... -
Numbering Rows
I have a couple of tables that I query, but I wish to add an extra column in the query which numbers the result set from 0-* (note, I don't wish to find out how many results there are). This is so that I can extract rows between two numbers for example: ...where rowcount BETWEEN 32 AND 40...
