Select last name between

[mcauliff]

What is the best way to code for selecting the row that have last names between 'a' and 'm'?

There are multiple columns in the query. It will be used in a spreadsheet and currently returns on the row limit of 65536 rows. I want to break it into selecting a through m and n through z.

I tried < 'n', but the results was not what I expected.

 

[SkipVought]

hi,

Where SubStr([last name],1,1) Between 'a' and 'm'

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

BTW,

Since your results are going to end up in Excel, why not use MS Query in Excel and query the DB2 database directly?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[MarcLodge]

As an alternative, you could write an opening macro as described here

http://support.microsoft.com/kb/120596

to split the data into separate sheets.

Or upgrade to Excel 2007 which I believe has over a million rows limit.

Marc

 

[mcauliff]

Thank for the reply. I am using the query function in Excel. I usually that function for quick tasks and code a program for others.

Not an option to upgrade to Office 2007.