Why sql query is not running...? in MSACCESS 2000
-
I want to trim the value so i just write a simple query in MSACCESS 2000 SELECT Trim([ItemName]) AS Expr1 FROM Items But it will give error "Undefind function "Trim" in expression" What to do...?
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
-
I want to trim the value so i just write a simple query in MSACCESS 2000 SELECT Trim([ItemName]) AS Expr1 FROM Items But it will give error "Undefind function "Trim" in expression" What to do...?
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
There is no TRIM commmand in T-SQL you have to use LTRIM then RTRIM as follows:
SELECT LTRIM(RTRIM(ItemName)) Expr1 FROM ItemsRegards GuyYou always pass failure on the way to success.
-
There is no TRIM commmand in T-SQL you have to use LTRIM then RTRIM as follows:
SELECT LTRIM(RTRIM(ItemName)) Expr1 FROM ItemsRegards GuyYou always pass failure on the way to success.
Thanks for reply but still query is not working Same error occurred for LTRIM function SELECT LTRIM(RTRIM(ItemFullName)) as Expr1 FROM Items:confused:
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...
-
There is no TRIM commmand in T-SQL you have to use LTRIM then RTRIM as follows:
SELECT LTRIM(RTRIM(ItemName)) Expr1 FROM ItemsRegards GuyYou always pass failure on the way to success.
could it be that he is missing references :confused:
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
-
could it be that he is missing references :confused:
"Many of life's failures are people who did not realize how close they were to success when they gave up." Thomas A. Edison
How to add the reference...? If I write LTRIM RTRIM in a query using C#.net and deploy the application to client site then same problem may occurred...?
Regards Pankaj Joshi If you want to shape your dreams into reality, please wake-up...