SQL Help

[Mike359]

I'm having a proublem with coding some SQL for my webiste. I'm using ASP and I have a probulem with this page.
http://www.polarismapcentral.com/maps/duke15maps.asp

Well see that happens when you click on the '#' link it shows all the maps. I want it to just show me the maps that begin with numbers. If anyone can help this would be greatly appercated.

[JonoF]

In Mysql I know you can do something like this:
SELECT * FROM table WHERE LEFT(mapname,1) >= '0' AND LEFT(mapname,1) <= '9'
How to convert that to SQL Server's way of thinking I'm not sure.

Jonathon

PS. You misspelled 'remember' on that page.

[Drazula]

This is a little more simple and readable, but accomplishes the same thing.

SELECT * FROM table WHERE ISNUMERIC(LEFT(mapname,1))

Good luck!