I have four tables,
1. First has Items,
2. Second has Features,
3. Third defines the ItemsFeatures

Running a query that adds up certain fields in our database and where
applicable returns a zero total.  Looking for a way to return only those
lines that are not zero value.
I'm new to this SQL thing, have experience in Access but am tripped up on

I have the following syntax:
"select itemnmbr, locncode, (qtyonhnd-atyalloc) as "QTY Available Main"
from iv00102 "
The results look like;

We are running SQLSERVER 2005.  The following query give the wrong answear.
WHY????
SELECT * FROM
(SELECT     Clearance.ClearDate as CLDATE, ORDER1.FULFILLMENTCODE AS FCODE

I am building a view for a report and one of the requirements is to grab the
user who is running the report.  What would this syntax look like?  I thought
it was getuser(), but no luck there.
Thanks,

I'm basically trying to replace non alpha characters of values in a couple
columns, but would prefer to create a ud-function or have a function in my
view do this for me rather than have to manually update every non-alpha
character.