sql statement

Results 1 to 2 of 2

Thread: sql statement

  1. #1
    Join Date
    Dec 1969

    Default sql statement

    my statement is like:<BR><BR>select * from tbl_A<BR>where 150.8 &#060;= field1<BR><BR>the result return records including the value of field1 is 150<BR>is there any way I can fix this problem? thanks.<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: sql statement

    I&#039;m guessing, but I suppose theres not many people round to help at the moment: because 150 is an int, sql is converting 150.8 to an int i.e. 150 so evaluating to true, try forcing it to use floats:<BR><BR>where convert(float,150.8) &#060;= convert(float,field1)

Posting Permissions

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