How to use custom sql functions

Posts   
 
    
WouterD
User
Posts: 12
Joined: 10-Mar-2009
# Posted on: 14-Apr-2009 10:25:39   

Hi,

I have created an assembly in MSSQL that validates a regular expression.

select dbo.RegexMatch( N'123-45-6789', N'^\d{3}-\d{2}-\d{4}$' )

Is it possible with LLBLGen to use this in a where clause with SelfServicing?

I would like the following sql:

... where (dbo.RegexMatch([Subject], 'this.*') = 1)

I hope you have some examples for me simple_smile

Thx

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 14-Apr-2009 10:39:49   

Please check Calling a database function, and pay specific attention to Specifying constants for function parameters