Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return all records with leading spaces

Status
Not open for further replies.

douggy

Technical User
Jan 18, 2001
78
GB
HI there,

Can you help me with thh SQL to return all records (Company Name Field) that have leading Spaces.

Kind regards
Mark
 
How about this:

Code:
select * from table where left([FieldName], 1) = " "

Hope this helps,

Alex

Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top