SELECT * from EditJournalBasicInformation where
-- (CNNo is null or CNNo = '')
isnull(CNNo,'')=''
-- and (ISSN is not null and ISSN != '')
and isnull(ISSN,'')<>''
and PATINDEX('[A-k]%', ClassName)>0
SELECT * from EditJournalBasicInformation where
-- (CNNo is null or CNNo = '')
isnull(CNNo,'')=''
-- and (ISSN is not null and ISSN != '')
and isnull(ISSN,'')<>''
and PATINDEX('[A-k]%', ClassName)>0