Query Help

Here is what I am trying to do.

I need to query a table like this:

SELECT PROPERTYTYPE, INDUSTRY, ORGNAME
FROM ORGANIZATION
WHERE (INDUSTRY LIKE '51%')
ORDER BY INDUSTRY

I provide the variable, in this case a range of numbers from the Industry
column starting with 51. This returns three columns of data, which two out
of three are populated. The field propertytype is most likely empty. If it is
empty I want the query to fill all the empty spots with another number I
provide. If its not empty, then I want to leave it alone.
.

Relevant Pages

  • RE: Query Help
    ... > If i am not wrong your query will look like this ... > SELECT isnull, INDUSTRY, ORGNAME ... The field propertytype is most likely empty. ...
    (microsoft.public.sqlserver.mseq)
  • RE: Query Help
    ... If i am not wrong your query will look like this ... SELECT isnull, INDUSTRY, ORGNAME ... The field propertytype is most likely empty. ...
    (microsoft.public.sqlserver.mseq)
  • Re: Count Problem
    ... Try saving this query as, say, qryIntermediary: ... SELECT Industry, Sum(SumOfCosts) As Costs, CountAs NoOfCustomers ... GROUP BY Industry, Customer) AS Subquery ...
    (microsoft.public.access.queries)
  • RE: Query returning many duplicate records
    ... If you wanted to calculate the number of establishments in a particular ... Then, in the query you would add the Industry column, and the ... "Roberto" wrote: ...
    (microsoft.public.access.queries)
  • Re: Query Improvement
    ... INDUSTRY: Index on IND_ID column. ... query you do not use a NVL function for the join. ... Even in older versions it should help to write it as an equijoin without IN or EXISTS and let the CBO decide about the driving table. ...
    (comp.databases.oracle.server)