Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: faithfulsinger
- Order by date
-
Between Statement not working in Case Select
You second solution seems to be working perfectly. I never gave the decimals a thought. My calculator is set to 2. Thank you so much.- faithfulsinger
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Between Statement not working in Case Select
I'm done staring at this. I'm sure it's something blatantly obvious, but I can't see why the between statement the 2nd and 3rd line of this HouseholdType case statement is not working. I've pasted partial results below the code. The first statement works as expected, but you will notice MID 25...- faithfulsinger
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
