It is a stored procedure as follows that takes out dashes in the social security number:

FUNCTION nodash
*takeout dashes in social security number
	PARAMETERS ssn_nodash
	ssn_nodash=alltrim(STRTRAN(ssn_nodash, '-', ''))
	return(ssn_nodash)
ENDFUNC 

I this can be done in select statement but not sure.


Thanks
Nick Patel