You are not logged in.
I'm trying TOP today, it's a very interesting tool.
I want to define a pattern to check validity of email in a sql Server Table. Patterns already exist for MySQL and Oracle but not for MS SQL Server. I tried to duplicate those existing and associate them to MS Sql Server connection type buut it doesn't work.
Can you tell me how can i define a compatible Email pattern to check my email fields in sql server Tables please ?
Thanks a lot.
Currently SQL Server does not provide native support of regular expressions. you must use an external library. See for example http://msdn.microsoft.com/en-us/magazine/cc163473.aspx or http://www.codeproject.com/KB/string/SqlRegEx.aspx
Once a regex function is defined on your server, you can configure TOP to use it in the preference page: "Data Profiler > UDF Preference".