Other ISNUMERIC SQL function

1. Usage of ISNUMERIC to check is postal code is numeric

SQL Server Query 1

            
 SELECT  

     CustomerID,  

     ContactName,  

     PostalCode,  

     CASE  

         WHEN ISNUMERIC(PostalCode) = 1  

         THEN 'Valid Numeric Postal Code'  

         ELSE 'Invalid Non-Numeric Postal Code'  

     END AS PostalCodeStatus  

 FROM Customers  

 ORDER BY CustomerID;  

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Columns("CustomerID", "ContactName", "PostalCode")  

     .Column(new CASE()  

         .When(new ISNUMERIC(new Column("PostalCode")).Equale(1))  

         .Then("Valid Numeric Postal Code")  

         .Else("Invalid Non-Numeric Postal Code")  

     , "PostalCodeStatus")  

     .From("Customers")  

     .OrderBy(new OrderBy().SetColumnAscending("CustomerID"))  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT CustomerID,
       ContactName,
       PostalCode,
       CASE WHEN ISNUMERIC(PostalCode) = @pMAIN_2507200220511581000 THEN @pMAIN_2507200220511581001 ELSE @pMAIN_2507200220511581002 END AS PostalCodeStatus
FROM Customers
ORDER BY CustomerID ASC;


            
        

Parameters (If used)

Query Results 1: