如果不是sql查询中的数据，则删除符号 [英] Remove the symbol if not data in sql query

问题描述

heyy ..



我有一个SQL查询（选择部分） -

heyy..

I have a sql query(a select part) -

SELECT
      (isnull(stock.StockName,'')+'-'+isnull(manu.ManufacturerName,'')+'-'+isnull(brand.BrandName,'')+'-'+isnull(model.ModelName,'')) as Stockitems 

在这个查询中，我用' - '符号分隔每个部分，If（ManufacturerName）或（BrandName）为null然后我得到输出如stockname - - 。





如果（ManufacturerName）或（BrandName）为null，我想删除' - 'sysmbol ..





任何想法..？

In this query , I have seperated each part by '-' symbol, If (ManufacturerName) or (BrandName) is null then I get output like "stockname - - ".


I want to remove the '-' sysmbol if (ManufacturerName) or (BrandName) is null..


Any idea..?

推荐答案

使用案例时：

Use CASE WHEN:

SELECT(
      isnull(stock.StockName,'') + '-' +
      CASE WHEN manu.ManufacturerName IS NOT NULL THEN '-' + manu.ManufacturerName ELSE '' END +
      CASE WHEN brand.BrandName IS NOT NULL THEN '-' + brand.BrandName ELSE '' END +
      CASE WHEN model.ModelName IS NOT NULL THEN '-' + model.ModelName ELSE '' END
      ) AS Stockitems

试试这个：



选择ProjectName +描述来自

（

选择

CASE WHEN

ProjectName IS NOT NOT NULL然后ProjectName +' - 'END作为ProjectName

，CASE WHEN

描述IS NOT NULL那么说明+' - '结束描述

来自项目

）temptable



希望，我会帮助你。

Try this:

Select ProjectName + Description From
(
select
CASE WHEN
ProjectName IS NOT NULL THEN ProjectName + ' - ' END As ProjectName
,CASE WHEN
Description IS NOT NULL THEN Description + ' - ' END As Description
from project
) temptable

Hope, I will help you.

这不是很漂亮，但应该有效：

This is not pretty but it should work:

select  
(
case isnull(stock.StockName,'') 
when '' then '' else stock.StockName + '-' end
+
case isnull(manu.ManufacturerName,'') 
when '' then '' else manu.ManufacturerName + '-' end
+
case isnull(brand.BrandName,'') 
when '' then '' else brand.BrandName + '-' end
+
case isnull(model.ModelName,'') 
when '' then '' else model.ModelName + '-' end
) Stockitems

这篇关于如果不是sql查询中的数据，则删除符号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！