how about this.... select * from TestName where History > 399 and History < 501
the above SQL is saying (in laymans terms) >From the table TestName gather all the column data and display ONLY those rows where data in History column is greater than 399 and is below 501. _OR_ Select ONLY those rows that have data in column History with values greater than 399 and below 501. Note this could be changed to History >= 400 and History <= 500 (note i am not sure in >= placement so it maybe => and =<). This I am assuming you want - how to take your layman speak and create an SQL statement. HTH. Dave. 2009/10/13 yvette roberson <yvrober...@gmail.com> > I am definitely an novice in writing but trying to practice and get up to > speed and would appreciate any help: > > In laymen terms I have a quey that I am trying to write with the following > columns > TestName (where testname '1' = History, TestName '2'=Math, TestName '3'= > Western Civilization, TestName '4'=Comp Apps, TestName '5'=Science. > TestSource (Clep, DSST, Exelisor) > Test Value (400,500,600,700,800,900) > TestUnit (101,102,103,104) > TestDte (datetime) > > When I pull these in an SSRS report it only returns one line of data I am > trying to get a list, with the following results > TestName TestSource Test Value TestUnit TestDte > History Clep 500 101 10/1/2009 > Math DSST 400 102 10/3/2009 > > I did try to use a case , but query only return one row, not sure how to > use > a loop in this instance. > > thanks in advance > -Yvette > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
