I have an alphabet list A thru Z which a user can click each letter and
retrieve all company names based on their first letter. Works OK, as
follows:
<a href="" B</a>
<cfquery name="q_product" datasource=#REQUEST.dsn1#>
SELECT pl_companies.*, LEFT(pl_companies.co_name,1) AS Alpha1
FROM pl_companies
WHERE co_Name LIKE '[#url.alpha1#]%'
ORDER BY co_name
</cfquery>
However, I have some company names that begin with a number, such as 3M
Company.
How would I create a similar scenario for numbers, rather than letters?
Do I have to create a link for each number 0 thru 9 or can I search just for
any number?
Thanks, Mark
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
