select [折旧年限] from [wzdb].[dbo].[Sheet1$] where isnull([折旧年限],'')=''
你那个看上去是null的应该是空字符串吧,试试: select 折旧年限 from [wzdb].[dbo].[Sheet1$] where 折旧年限 is null or 折旧年限=''
从excel出来的,应该这样ltrim(rtrim(isnull(col,'')))=''
也不可以呢,抓不出来,这个是从excel中导过来,我要把null值转换掉,可是抓不出来
这个呢,试试看: select 折旧年限 from [wzdb].[dbo].[Sheet1$] where 折旧年限 is null or LTRIM(RTRIM(折旧年限)) = '' or (PATINDEX('%[0-9]%',折旧年限) = 0 and PATINDEX('%[a-z]%',折旧年限) = 0 and PATINDEX('%[吖-座]%',折旧年限 = 0)
你所谓的null有没有可能是字符串'null'? 用: select [折旧年限] from [wzdb].[dbo].[Sheet1$] where upper(isnull([折旧年限],'NULL'))='NULL' 试试看
select [折旧年限] from [wzdb].[dbo].[Sheet1$] where isnull([折旧年限],'')=''
select 折旧年限 from [wzdb].[dbo].[Sheet1$] where 折旧年限 is null or 折旧年限=''
select 折旧年限 from [wzdb].[dbo].[Sheet1$]
where 折旧年限 is null
or LTRIM(RTRIM(折旧年限)) = ''
or
(PATINDEX('%[0-9]%',折旧年限) = 0
and PATINDEX('%[a-z]%',折旧年限) = 0
and PATINDEX('%[吖-座]%',折旧年限 = 0)
用:
select [折旧年限] from [wzdb].[dbo].[Sheet1$] where upper(isnull([折旧年限],'NULL'))='NULL'
试试看