SELECT 300-FeesPaid AS OutstandingFees
FROM Fees
cokelite
Last Activity: Dec 17 '08, 07:18 AM
Joined: Nov 21 '08
Location:
-
Thanks uncle, your solution seems to be just what i was looking for :)Leave a comment:
-
Yup. I want the query to return only the artists who visited all these cities.Leave a comment:
-
My point is, that I only want to know the artists who have visited in each of these cities.Leave a comment:
-
Seems to me you don't have spaces around the word Art in your actual query. So use '% Art %' instead of '%Art%'.
I would do it like this:
WHERE JobTitle like '% Art %' OR JobTitle like 'Art %' OR JobTitle like '% Art'Leave a comment:
-
Filtering different conditions in the same field
Hi. I'm developing a reporting application (.NET & MsSqlServer 2000) that automatically generates the sql script for the report's data source based on the parameters passed to it.
Let's say I have a table CONCERTS:
Artist varchar(50)
PerformanceCity varchar(50)
DateOfPerforman ce DateTime
Now I want a report displaying only the artists who have at some time performed in London AND in Paris...
No activity results to display
Leave a comment: