BAQ with Hyphens

Epicor ERP 10
1

I have built a BAQ that is pulling SSN’s . I would like to remove the hyphens in the BAQ. I thought you could do it in format but I am having no success. Is this possible in the BAQ?

2

@ajr117 You can create a calculated field in the BAQ,
REPLACE(yourtable.yourssnfield, ‘-’,’’)

1 Like
3

Thanks for the info, that did the trick