Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Dadda

  1. Dadda

    SQL SELECT... WHERE Replace(...) = 'value'

    I've got a little help from a friend and it seems that the problem is a little bit moore complex than I've described above. The Column 'Pnr' contains some posts that are empty, hence the "Type mismatch". So, with the SQL-question below, I got the result I wanted: SELECT ID, Pnr, KortNr FROM...
  2. Dadda

    SQL SELECT... WHERE Replace(...) = 'value'

    Thanks guys for your answers... dhookom: That one I've tried, I get the result I want, a list with the correct formatting in the column "PnrNoHyphen". The problem seems to lie with the WHERE-statement. If I use the code SELECT ID, Pnr, KortNr FROM tbl_Person WHERE (Replace(Pnr, '-', '')) =...
  3. Dadda

    SQL SELECT... WHERE Replace(...) = 'value'

    I have a column in a table containing a sort of social security number. The mask for these numbers are nnnnnn-nnnn (750701-1234). I want to use the input of only numbers to be able to find the right post, for example if I search for "7507011234" I want the SQLquery to actually find the post...
  4. Dadda

    Connecting to a remote Access database

    I want to read data from a database (i.e. http://www.test.se/test/test.mdb) with a asp-page. Is this possible? //Dadda
See more

Part and Inventory Search

Back
Top