Hi All,

I have used on the query to Sage 300 BI report, but it is getting an error on conversion.Please see the below and advise me. 

GLAMF.ACSEGVAL01 IN (CONVERT(varchar(10), @Segmentcode@))

The Error is "[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','."

Please advise.

Prakash

Views: 33

Replies to This Discussion

Try:
IN CAST ((@Segmentcode@) AS VARCHAR(10))

RSS

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service