Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    7

    Unanswered: convert text to int/number during query

    Hello,

    is there a way like in MSSQL to convert a text value to number during the query?

    the text field contains only values and if I want to do a where field>1024 if bugs out as it ain't a real value.

    I tried to change the type to number but it warns that it will trash values if I do so

  2. #2
    Join Date
    Jul 2002
    Posts
    7
    never mind got it solved by setting it to number AND double instead of long int

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •