Skip to Content
0
Mar 03, 2009 at 11:46 PM

Formatted search with UDF and syntax question

34 Views

Can you explain the syntax with when to use the dollar sign and negative in writing a query for a formatted search based on user entry?

I now want to create a formatted search to pull values based on the user's entry into a UDF on the item master screen.

User entry into UDF U_Customer Code

to create Formatted search for UDF U_Rep01

I tried the following, but it does not work.

SELECT T0.U_REP01 FROM dbo.OCRD T0

WHERE T0.CARDCODE = $http://$OITM.U_CUSTOMERCODE

Thanks.

Please advise.