WHEN 1 THEN CONVERT(NUMERIC(6, 2), VendorInvoiceAmount)įROM should run in your environment: SELECT CASE ISNUMERIC(VendorInvoiceAmount) SELECT CASE ISNUMERIC(VendorInvoiceAmount) Yup, it's an invalid SQL SELECT statement. My MSDN Page My Personal Blog My Facebook Page Please Mark This As Helpful if it helps to solve your issue Please Mark This As Answer if it solved your issue If you want to include them too you need to write condition as this select distinct k.VendorInvoiceAmount,k.valid See this SELECT ISNUMERIC(NULL),ISDATE(NULL) Hence validation functions like ISNUMERIC,ISDATE etc should always return false for it NULL represents an unknown value so you wont be able to determine a data type for it (select CaseNumber,VendorInvoiceAmount, dbo.is_numeric(VendorInvoiceAmount)as valid What is the workaround for that? select distinct k.VendorInvoiceAmount,k.valid ![]() I can ask the users to correct the "P" record, but "NULL" are valid i cantįilter them. Its showing validty 0 for 'p' and 'NULL'. ![]() Please see the below query and result set. ![]() Thanks Visakh16, from the link i created a function and executed the sql.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |