Fordraiders
asked on
weird character will not disapper after trim update
access 2003
need a function if necessary please...or update statement
I have a field in a table that has a box character at the end of the field.
I tried using:
UPDATE SapAlt_Staging_Prmdb025 SET SapAlt_Staging_Prmdb025.al t_acc_mate rial_no = Trim([alt_acc_material_no] );
but the character will not go away ?
see pic below
Thanks
fordraiders
weird-character.png
need a function if necessary please...or update statement
I have a field in a table that has a box character at the end of the field.
I tried using:
UPDATE SapAlt_Staging_Prmdb025 SET SapAlt_Staging_Prmdb025.al
but the character will not go away ?
see pic below
Thanks
fordraiders
weird-character.png
you can also use the replace() function, but you have to know the ascii value of thet weird character.
try this
update table
set [fieldName]=replace(replac e(replace( [fieldName ],chr(13) & chr(10),"") ,chr(13),""),chr(10),"")
try this
update table
set [fieldName]=replace(replac
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to both
if you want the first 6 characters, use
left([fieldName],6)
update table
set [fieldName]=left([fieldNam