|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
How do I create an "input mask" in SQL server?
I tried the search engine but it only took me to the frontpage. So I had to create a new thread, I also searched through google but I only found input masks for Access. I only want to know how I create input masks in Microsoft SQL Server?
thanks in advance. |
|
#2
|
|||
|
|||
|
Hi
Ur Problem Can Be Solved By Setting Check Constraint. For Eg: Create Table T2 ( cEmpCode char(5) Constraint chkEmpCode Check (cEmpCode Like 'E[0-5][0-9][0-9][0-9]'), cCity Char(15) Constraint chkCity Check (cCity In('Boston','Paris')), iAge int Constraint chkAge Check (iAge Between 1 And 99) ) Last edited by deepak_ld : April 13th, 2004 at 12:52 PM. |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > How do I create an "input mask" in SQL server? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|