I've got dirty data in a column with variable alpha length. I just want to strip out anything that is …
tsql sql-server-2008-r2 substring patindexI'm confused over what to use? Basically I need to have a search string that can search a single column …
sql-server full-text-search contains sql-like patindexI have come across this line in an old report that needs converting to SQL Server. REGEXP_LIKE (examCodes, learner_…
sql sql-server oracle design-patterns patindexI am trying to use the PATINDEX function in SQL Server 2008 R2 to extract the value 3 from the string Charged …
sql sql-server-2008 patindexI tried using Instr for this, but didn't work, so I found the supposed to be equivalent using PatIndex and …
sql-server sql-server-2008 patindex charindex