if you want only theose rows present in table2 but not in table1 then user the following query:

select * from table2 where col2 not in(select col1 from table1)

But if...

when you put 5:45 in a cell it automatically sets the datatype of the cell 'DATE'(hh:mm format).So when you get SUM using formula it will autometically give you 11:10.

'PRICE' may be the reserved keyword.Pls try the code after changing it.

I presume it will work.

Yeah.. You have to check first whether the string is empty or not.

You can always convert a varchar field to a decimal field.I have tested this by creating a Test Table with a decimal field with length=5,precision=9,scale=3.

And then running the follwing query:

insert...

select (select count(*) from Table_Name where Column_Name<5) as 'LESS',

(select count(*) from Table_Name where Column_Name>5) as 'MORE'