Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and then ...

CREATE TABLE table2 ( bigint_col BIGINT, string_col TEXT ENCODING DICT(32)); SELECT regexp_extract("string_col", '([[:digit:]]+)', 0) AS tmp FROM table2; SELECT ...