I don't want to create the file if it dosen't exist I just want to see if it's there. Like have a variable return True if it is in fact there.
Thanks,
Nick
I am trying, with a spectacular lack of success, to return TRUE and FALSE values in my SELECT statement. This SQL (below) is simply illustrative. It doesn't reflect my real world query. I would just like to know how to return such values in T-SQL.
Code:
SELECT [PR_PRODUCT]
,TRUE AS [CostMissing]
FROM [DBManagement].[dbo].[vwCustStock]
WHERE ([PR_RANGE] In(70,91))
GO
Msg