Check Constraint 1

[woogoo]

Hi,

I want to add a check constraint that will allow a column to contain either A, A3, A4 or A5. At present I've written it as Col = 'A' OR Col='A3' ... but I was hoping to use something like Col='A|A[3-5]' but this doesn't appear to work. Any suggestions?



woogoo

 

[bborissov]

Col1 = 'A' OR Col1 LIKE a[3-5]

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[SimonSellick]

Or

Col1 in ('A', 'A3', 'A4', 'A5')