Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Query

Author

Topic

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2009-05-12 : 21:09:53

I need a function which should return the 1 for valid result 0 for invalid result.

Rule:

Function Input parameters

@Value
@ValueMinlength
@ValueMaxlength
@DataType
@Null

Input values for function to be passed
@Value = 10000
@DataType = numeric
@ValueMinlength = 5
@ValueMaxlength = 5
@ColumnIsNull = Null

Output :

1

Please help

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-12 : 23:43:05

You can write a few IF statements to check this.

E 12°55'05.63"
N 56°04'39.26"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources