home / study / engineering / computer science / computer science questions and answers / Hi Everyone. Hope You Are Well. I Need A Help For Sql Query Please I Have This Qurey Which ...

Your question has been answered

Let us know if you got a helpful answer. Rate this answer

Question: Hi everyone. Hope you are well. I need a help for sql query please I have this Qurey which is goi...

Hi everyone.

Hope you are well. I need a help for sql query please I have this Qurey which is going to show the data between the range that exist in data base. But I am enter the range between 1 to 500 which I suppose to see all data between 1 to 500 but I am getting data over the 500 also, is any body can help for this issue.

Best regards

my SQL Qurey:

SELECT

CONVERT(varchar, CAST(r.[Balance Due Adj] AS money), 1) AS 'Balance Due'

FROM RPT_Calculated r WHERE(r.[Balance Due Adj] BETWEEN '1' AND '500')

OUTPUT:

Balance Due

11603.05

102.50

2803.40

1906.14

2047.00

34307.22

228.06

10005.51