LTrim$ Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text column that has leading and training blank spaces (not nulls). I am trying to use an update query with the LTrim$ function to remove the leading spaces. The syntax should be LTRIM$([column name]), but this is not working as it is trying to insert the string literal column name into the value of the column for all 207 rows. What am I doing wrong?
 
Try using:

Trim([FieldName])

--
HTH
Van T. Dinh
MVP (Access)



Stumped said:
I have a text column that has leading and training blank spaces (not
Click to expand...
nulls). I am trying to use an update query with the LTrim$ function to
remove the leading spaces. The syntax should be LTRIM$([column name]), but
this is not working as it is trying to insert the string literal column name
into the value of the column for all 207 rows. What am I doing wrong?
 
OK, can you copy and post the SQL of your query?

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

This might give us a hint.
 
Back
Top