How to use a Function in SQL

[nat1967]

Hi everyone,

Is it possible to use a function in a SQL query?

Here is the SQL:

WHERE USER = "nharrison"

What I would like to do is call a Function called Husers. This function
builds a list of all the current users that I need to query on. Currently,
I have each one listed in the SQL statement. However, that gets to be a
nightmare if users are added or removed.

The function works and brings back this:

'nharrison', Or 'tomcat', Or 'ddog'

I just dont know how to have the Where statement call this function.

any thoughts?


Have A Great Day!!!,

Nathan
Senior Test Lead

 

[jebry]

Hi Nathan!

I am not sure if you can do that in the criteria or not. Is it possible to get all the names you need using a query? If so then you can use a subquery like this:

Where User IN ("Select Name From YourTable Where YourCriteria&quot

hth


Jeff Bridgham
bridgham@purdue.edu