SQL Functions

[eraser950]

Hello can any one please tell me how can i perform the following actin in SQL if ((sizee == "") && (sidee == "") && (color == "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + orgnShortName; } else if ((sizee == "") && (sidee == "") && (color != "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + color + "-" + orgnShortName; } else if ((sizee == "") && (sidee != "") && (color == "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sidee + "-" + orgnShortName; } else if ((sizee == "") && (sidee != "") && (color != "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sidee + "*" + color + "-" + orgnShortName; } else if ((sizee != "") && (sidee == "") && (color == "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sizee + "-" + orgnShortName + "*"; } else if ((sizee != "") && (sidee == "") && (color != "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sizee + "*" + color + "-" + orgnShortName; } else if ((sizee != "") && (sidee != "") && (color == "")) { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sizee + "*" + sidee + "-" + orgnShortName; } else { ItemComputerCode = PartGroup + "-" + Model + "-" + Brand + "-" + sizee + "*" + sidee + "*" + color + "-" + orgnShortName; } return ItemComputerCode; thnx in advance Regards

[PIEBALDconsult]

It would likely involve case, but I wouldn't do it in SQL, just clean up the code you have.

System.Text.StringBuilder sb = new System.Text.StringBuilder() ;

sb.Append ( PartGroup ) ;
sb.Append ( "-" + Model ) ;
sb.Append ( "-" + Brand ) ;

string sep = "-"

if (sizee != "") { sbAppend ( sep + sizee ) ; sep = "*" ; }

if (sidee != "") { sbAppend ( sep + sidee ) ; sep = "*" ; }

if (color != "") { sbAppend ( sep + color ) ; sep = "*" ; }

sb.Append ( "-" + orgnShortName ) ;

return ( sb.ToString() ) ;

[eraser950]

thnx,but if ay one plz do it in sql