SQLSRV server side regex search

raffgras

Hello, I am trying to search for an exact string using a regex pattern:

table.columns(1).search("^123$", true, false).draw();

The problem is, that SQLSRV does not seem to support the generated REGEXP keyword (according to the image)

I wanted to know if there is a way to use regex on SQLSRV.

Thank you in advance.

colin

Hi @raffgras ,

This page here should help,

Cheers,

Colin