blank space 2

[pgtek]

hello
crystal 8.5 odbc sql database
I have a table that contains last name,varchr(24)
the user fills in the space on a form.
some will leave spaces between the boxes to fill in
example

B_R_O_W_N
or some like this
BR_OWN

I need the report to filter out the blank spaces enter my the user so the last name will not contain any blank spaces
example: BROWN
NOTE: The blank space might be anywhere in the fill box

I have tried Trim({Last_Name})
Not sure if this is the way to go.
Than you for your assistance



pgtek

 

[MisterMo]

replace({table.Field},' ', '')

Mo

 

[pgtek]

Hi Mo
replace({table.Field},' ', '')
are those single quote????

thanks



pgtek

 

[kskid]

You can use either single or double quotes.

-LW