|
 |
access thread: How to ignore leading spaces in "Select From Where Clause"
Message #1 by "Mike Session" <websource@p...> on Thu, 17 May 2001 01:04:53
|
|
I want to be able to ingnore leading spaces in a text field when using the
Where option in a Select statement. Would someone please advise. I have a
fairly large database that was built using form input. The user has added
spaces to the beginning of some fields, and this causes the compare to
fail. If I manually remove the spaces, the compare works. Please Help.
Mike
Message #2 by "John Ruff" <papparuff@c...> on Thu, 17 May 2001 02:42:37 -0700
|
|
Look at using LTrim to remove the spaces. (There are three functions that
remove spaces. LTrim, RTrim, Trim)
John Ruff - The Eternal Optimist :)
-----Original Message-----
From: Mike Session [mailto:websource@p...]
Sent: Thursday, May 17, 2001 1:05 AM
To: Access
Subject: [access] How to ignore leading spaces in "Select From Where Clause"
I want to be able to ingnore leading spaces in a text field when using the
Where option in a Select statement. Would someone please advise. I have a
fairly large database that was built using form input. The user has added
spaces to the beginning of some fields, and this causes the compare to
fail. If I manually remove the spaces, the compare works. Please Help.
Mike
Message #3 by "WebSource" <websource@p...> on Thu, 17 May 2001 06:55:34 -0700
|
|
Thanks John. I'll take alook.
Mike
----- Original Message -----
From: "John Ruff" <papparuff@c...>
To: "Access" <access@p...>
Sent: Thursday, May 17, 2001 2:42 AM
Subject: [access] RE: How to ignore leading spaces in "Select From Where
Clause"
> Look at using LTrim to remove the spaces. (There are three functions that
> remove spaces. LTrim, RTrim, Trim)
>
> John Ruff - The Eternal Optimist :)
> -----Original Message-----
> From: Mike Session [mailto:websource@p...]
> Sent: Thursday, May 17, 2001 1:05 AM
> To: Access
> Subject: [access] How to ignore leading spaces in "Select From Where
Clause"
>
> I want to be able to ingnore leading spaces in a text field when using the
> Where option in a Select statement. Would someone please advise. I have a
> fairly large database that was built using form input. The user has added
> spaces to the beginning of some fields, and this causes the compare to
> fail. If I manually remove the spaces, the compare works. Please Help.
> Mike
>
Message #4 by "WebSource" <websource@p...> on Thu, 17 May 2001 16:19:27 -0700
|
|
It worked great. Thanks again.
Mike
----- Original Message -----
From: "John Ruff" <papparuff@c...>
To: "Access" <access@p...>
Sent: Thursday, May 17, 2001 2:42 AM
Subject: [access] RE: How to ignore leading spaces in "Select From Where
Clause"
> Look at using LTrim to remove the spaces. (There are three functions that
> remove spaces. LTrim, RTrim, Trim)
>
> John Ruff - The Eternal Optimist :)
> -----Original Message-----
> From: Mike Session [mailto:websource@p...]
> Sent: Thursday, May 17, 2001 1:05 AM
> To: Access
> Subject: [access] How to ignore leading spaces in "Select From Where
Clause"
>
> I want to be able to ingnore leading spaces in a text field when using the
> Where option in a Select statement. Would someone please advise. I have a
> fairly large database that was built using form input. The user has added
> spaces to the beginning of some fields, and this causes the compare to
> fail. If I manually remove the spaces, the compare works. Please Help.
> Mike
>
|
|
|
View Cart
