Filtering specific numbers

Setting up a recordset in Dreamweaver MX

[rokenn3]

Hello,

I am trying to set up a page with nine recordsets. However, I want to filter each recordset by the ID number of the record. For instance, I want one recordset to filter all ID's ending with 1, another to filter all the ones ending with 2, another for 3's and so on. How do I set this up? Any idea?

RKIII

[macrost]

rokenn3,
Have a look here under scalar functions for sql.
h*tp://www.w3schools.com/sql/sql_functions.asp

Mac

[rokenn3]

not sure of how this works. Still a newbie here! Can you help more?

RKIII

[mattglet]

you might have a little more luck in the Text Editor forum [webmasterworld.com]. all the dreamweaver guru's hang out there.

-Matt