CODEWITHSUNDEEP
sqlsql-serverregexstored-procedures
kurupt_89
kurupt_89

Reputation: 1592

Using regular expression within a stored procedure

What is the regular expression pattern that enables every input besides characters? So far this is what i have -

CREATE PROCEDURE Paging_Movies
@alphaChar char(1)
AS
if @alphaChar = '#'
select * from Movies where movies like '[0-9]%'
else
select * from Movies where movies like @alphaChar + '%'

Upvotes: 0

Views: 13438

Answers (2)

Town
Town

Reputation: 14906

SQL Server 2008 R2 has some regular expression functions built-in.

Here's a link explaining how to extract them and use them in your own database.

Upvotes: 2

Abe Miessler
Abe Miessler

Reputation: 85116

If you want true regular expression pattern matching you will need to roll your own CLR UDF. This link goes over how to do that:

http://msdn.microsoft.com/en-us/magazine/cc163473.aspx

Keep in mind that you can only do this in SQL Server 2005 or higher.

If you just want non-alpha you can do this:

'([^a-z])'

Here is the documentation for SQL Server like:

http://msdn.microsoft.com/en-us/library/ms179859.aspx

Upvotes: 2

Related Questions