12 Replies Latest reply on Jan 25, 2007 8:58 AM by Charlie Griefer

    select query with numbers

    namtax Level 1
      i have an index on my site, which select bands by the letter that is clicked

      <cfquery name="results" datasource="#APPLICATION.DataSource#">
      SELECT *
      FROM artist_art
      WHERE bandname_art like '#url.firstletter#%'
      thing is, im trying to group all bands that begin with a number together, and am unsure of the symbol which refers to "all numbers" in coldfusion..
      Have looked everywhere, but this place seems to be the only place with the answers lately, so...