I've got dirty data in a column with variable alpha length. I just want to strip out anything that is not 0-9. I do not want to run a function or proc. I have a script that is similar that just g...

I am in need of Postgres equivalent of the SQL function patindex

I'm writing different queries in SQL Server. I have 2 tables, Employees and Departments. Table Employees consists of EMPLOYEE_ID, ENAME, ID_DEP - department id. Table Departments consists of ID_DEP...

I have come across this line in an old report that needs converting to SQL Server. REGEXP_LIKE (examCodes, learner_code) examCodes being the source and learner_code being the pattern. I know th...

CREATE TABLE #tmpTbl (m VARCHAR(100)) INSERT INTO #tmpTbl VALUES (',[Undergraduate1]') ,(',[Undergraduate10]') ,(',[Undergraduate11]') ; GO select LEFT(m, PATINDEX('%[0-9]%', m)-1) as a, SUB...

In the below code example, all results should return 7. Those with aliases beginning X however, do not. select --where matches patindex('%-%' ,'111111-11') dash --not a special character, so wo...

I need to check the library used by several stored procs that extract data from a remote server. I have (with SO help, see SO 21708681) built the below code: DECLARE @tProcs TABLE ( procID int ...