In Access SQL I was able to write in such manner:
SELECT CBOOL([Client] Like '%Corp%') AS IsCorp FROM tblMain
How to correctly convert this expression to T-SQL?
Is there a laconic possibility without CASE WHEN... construction?
Do you have to parse the client string to know whether it is a client corporation? That is bad design. You should add an explicit column like IndCorp or CorpFlag, ... or a FK to a table holding all possible values, to store that property.
In my tables IndColumns are indicator columns of type CHAR(1) with a check constraint limiting their values e.g. CHECK (IndColumn IN ('Y', 'N')). You could also use BIT instead of CHAR(1), but that is not standard SQL.
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2. Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages