How to use varibles in SQL query

[OD]

I'm tring to upsize my access 2007 database to SQL. In access I created a
function to accept a varible, then I could use the function in the query.

SEE BELOW:

Public Function IDNum() As Integer
IDNum = varID
End Function

Can this be done if I use SQL Tables?

Thanks
OD

 

[PieterLinden via AccessMonster.com]

I'm tring to upsize my access 2007 database to SQL. In access I created a
function to accept a varible, then I could use the function in the query.

SEE BELOW:

Public Function IDNum() As Integer
IDNum = varID
End Function

Can this be done if I use SQL Tables?

Thanks
OD

If you are trying to upsize your function, then no. You would have to
rewrite it in T-SQL. Then you could create dynamic SQL or a native SQL
function in your stored procedure