How To Convert Numeric to Alphanumeric

[zal_parchem2]

A customer would like to select a suggested RMA (Return Material Authorization) code on the Business Partner Activity window using a User-Defined Field called U_RMAFromAct (alphanumeric, 18).

They want to click on the UDF's Formatted Search u201Cmagnifying glassu201D in the UDF, see only one code, and select it to appear in the UDF Field.

The RMA code should look like this:

612345-12

Where the 612345 is the OCLG.CardCode (alphanumeric), a dash between, and where 12 is the OCLG.ClgCode (numeric).

I am unable to combine alphanumeric and numeric togetheru2026

Anyone have suggestions on how to convert numeric to alphanumeric and what the Formatted Search SQL should look like?

Thanks bunches guys!!!

Zal

[former_member204969 · Accepted solution]

Try something like this:

OCLG.Cardcode+'-'+ltrim(str(OCLG.ClgCode))

[zal_parchem2 · Accepted solution]

Istvan - you are the champ - it worked perfectly...

thanks bunches and enjoy your points...

Zal