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
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