Hey all,

I am trying to use a Select statment inside a VBScript that calls to a function in the script for one of its select arguments. anyway, ITS NOT WORKING

the select statment WITHOUT the function works perfect, i just cant get it to work with the function. here is a sample of what i am using for code.

Code:
objDB.Execute("SELECT Colmn1, Colmn2, '" & myfunction(Colmn1) & "' As NewColmn FROM MyDB.MyTable")

myfunction(Var1)

Dim NewValue
NewValue = (Var1 / 100)
myfunction = NewValue

End Function
if i remove the "Colmn1" part of my Select Statment function call and replace it with a static value such as "111019" the code works but only for that static value, i want it to use Colmn1 value as the value for the function.


any help would be GREAT