trim space in front of data so i can use it in select query

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

Guest

could someone give me an example of how to use Ltrim function please?
 
In SQL

Select LTrim([FieldName] As NewFieldName From TableName

Or, in query design add a field in the query
NewFieldName: LTrim([FieldName]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to trim leading spaces that are not removed by Trim 3
remove leading space in field in Access 2
Trim in Query Error 1
TRIM function in query 2
Trim command 7
trim in query 6
SQL Trim function 1
msaccess to mssql server automatic query conversion 4

Back
Top