Help with User Defined Function

[jgd1234567]

Hi i have a user defined function (called IsValid) which has one parameter and returns a bit. I need to create a sql statement which returns any rows in a table where the function returns 1 based on the inputted value, ie

SELECT * FROM Groups WHERE dbo.IsValid(GroupID) = 1

But the above does not work. I'm pretty new to user defined functions and do not understand how and where i can use them. I could create the above as a stored procedure if i have to but i still do not understand how this could be achieved.

Appreciate if someone could help.

 

[bborissov]

Could you post function code?
The statement above is valid, so maybe there is something about your function

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[AlexCuse]

What do you mean, does not work? If its' not returning any results, perhaps your function is written in such a way that no GroupID's are actually valid?

Hope this helps,

Alex

[small]----signature below----[/small]
Now you can go where the people are one!
Now you can go where they get things done!

 

[Skittle]

Has your function been set to RETURN the bit value?
The BEGIN...END must at some point issue a RETURN but I would guess you have treated it like a stored procedure and not set this correctly.

Post the code so we can see.


Dazed and confused

 

[jgd1234567]

Hi cheers people, you guessed right. It was the function that was causing the problem after all.

Appreciate your help.