>>I wrote a user defined function called CleanString:
>>
>>
>>Public Function CleanString(String2Clean As String)
>>
>> RetVal As String
>>
>> String2Clean = Replace(String2Clean, "'")
>> String2Clean = Replace(String2Clean, "(")
>> String2Clean = Replace(String2Clean, ")")
>> String2Clean = Replace(String2Clean, "$")
>>
>> CleanString = RetVal
>>
>>End Function
>>
>>
>>I want to call it in a query I'm working on. So in the expression builder I tried:
>>
>>
>>VN-PAID: CleanString([VEN_YTDPaidAmt])
>>
>>
>>I get "Undefined function 'CleanString' in expression".
>>
>>How do I do this?
>
>In SQL Server it would be dbo.CleanString([myField])
Ok....
???
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people