Account Home | Help | Blog | Contact us | Log Out

Add check constraint for web addresses to SQL 2000

Posted By: siteadmin on 23/03/2012 22:05:00

Without the luxury of Regex functions in MS SQL 2000 you can still use check constrains to apply formatting to your table columns.

Here is the check constraint phrase to ensure a web address, with a trailing / is entered:

([col] like '%://%/')

and then

({ fn LENGTH(col) } - { fn LENGTH(REPLACE(col, '/', '')) } > 3)