bill201
asked on
how to use trim in access 2013 to cut extra spaces
hi
i have some strange problem that when i make with a query for example:
i have some strange problem that when i make with a query for example:
NSERT INTO IskitTemp ( ProductName ) Select ProductName From ProductTbl
i get a list with all products name with extra spaces that increase the character in the productName field to 250 characters (like the Restriction of The maximum amount of characters that can stored in the product name in the producttbl, but in the producttbl it's dosn't have so much spaces so why in iskittemp is so much spaces ?
ASKER
there is something wrong in your code, it's not working and i get an error message
Hi,
What is Definition of Product Name In the ProductTbl?
EDIT Are you using VARCHAR(n) because CHAR(n) will add blanks at the end?
Regards
What is Definition of Product Name In the ProductTbl?
EDIT Are you using VARCHAR(n) because CHAR(n) will add blanks at the end?
INSERT INTO IskitTemp ( ProductName ) Select Trim(ProductName) From ProductTbl
Regards
ASKER
i create it with sql string :
the Definition of Product Name In the ProductTbl is short text field size (255)
the iskttemp i create with a sql string like this
the Definition of Product Name In the ProductTbl is short text field size (255)
the iskttemp i create with a sql string like this
CREATE TABLE (ProductName CHAR (255))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a lot, now there is no problem
whitout more info about IsKitTemp
pls try
Open in new window
Regards