Return Boolean value

[travisbrown]

Is there a way to return a boolean value based on whether the rs returns any records or not?

Basically,

SELECT variableInteger
FROM (SELECT integerColumn FROM tbl)

If it finds the variable value in the array, return 'true', if not, return 'false'

Thanks kindly.

 

[swampBoogie]

There is no boolean data type in Tsql.

What you can do is

if exists (select * from t) 
   select 1 -- true
else
   select 0 -- false

 

[travisbrown]

Cool. Thanks. Now to just be a pain, I have to get this to work in Access as well. Is there something similar? I don't think you can use 'EXISTS' in Access.

I can get by with this, I think. Is there a better way?

SELECT
DISTINCT
IIF(((SELECT MAX (m_i_ticket_number)
FROM tblMyIssues
WHERE m_u_userID = vUID AND m_i_ticket_number = vID)) IS NULL, 'false', 'true')
FROM tblMyIssues