Sorting a database by part of the field 1

[btween]

I have an access database that has a simple table with 2 fields:

id and url.

It basically stores a large numer of web domains. What I'm trying to do is sort this table by extensions, so I can have all the .coms together followed by the .nets, and I don't know how to query it to do this.

the second thing I need to do is sort by a part of the domain name.

Let's assume I have 2 sites one,

http://www.thechesssource.com

and

http://www.funchess.com

How can I get these 2 to be together, sorted by the common word chess.

Any help would be greatly appreciated.

 

[SkipVought]

btween,

select *, right(url,3) as EXT from Domains order by right(url,3)

On your second requirement, will you be selecting on a single string of your choice like "chess"?

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[wemeier]

You can't group URL's by a part of the domain name if you don't know where in the domain name "chess" is. However, you can group domains with "chess" in them if you filter all of the URL's, looking for those with "chess" in it by the following:

DoCmd.AppyFilter , "URL Like '*chess*'"

Cruising the Information Superhighway
_{(your mileage may vary)}

 

[btween]

I tried running this query

SELECT url
FROM tblName;

DoCmd.ApplyFilter , "url Like '*chess*'"

but I am getting an error: characters found after end of sql.


I am assuming this command has to be integrated in the query. Any help with the syntax would be great.

 

[r937]

SELECT url
FROM tblName WHERE url LIKE '*chess*'


rudy

http://r937.com/

SQL Consulting