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!

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

Choose row with longer strings 1

Status
Not open for further replies.
kupe

kupe

Technical User
Sep 23, 2002
376
I want to say

WHERE Address >= CHAR.LENGTH(Address, 20);

only not quite like that because it doesn't work. Anyone spot the undeliberate mistake please? Cheers
 
Sort by date Sort by votes
Brilliant! I spent an age on that. Thank you very much.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
438
Chris Miller
Chris Miller
waubain
  • Locked
  • Question
Show rows results on same row when Group BY fields 1
Replies
6
Views
378
SkipVought
S
jawadfrhad
  • Locked
  • Question
how make row to column
Replies
4
Views
186
jawadfrhad
jawadfrhad
BJZeak
  • Locked
  • Question
need help with .sql insert statement
Replies
1
Views
140
spamjim
spamjim
eizs002
  • Locked
  • Question
Connect MS Access to mysqlDB without ODBC
Replies
3
Views
320
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top