No announcements

Help - isNumeric, isEmpty var return

I ran this script: dim profile19, qty profile19 = 6 if Not isEmpty(profile19) then if isNumeric(profile19) then qty
| 10 Replies | 613 Views | Created by jmatt1012 - Monday, October 6, 2014 3:15 PM | Last reply by Bill_Stewart - Monday, October 6, 2014 7:27 PM

MDX IsNumeric( WholeNumber ) returns false

Here is a part of the MDX query roughly: CASE WHEN IsEmpty([Sheet1].[value].CurrentMember.MemberValue) OR NOT IsNumeric([Sheet1].[value].CurrentMember.MemberValue) ...
| 3 Replies | 9173 Views | Created by lusien - Wednesday, September 29, 2010 7:35 PM | Last reply by Ed Price - MSFT - Sunday, November 3, 2013 11:59 PM

SELECT //NON EMPTY     { FILTER( [Measures].[Balance], ISEMPTY([Charge Off Date].[Date SK] ))     } ON COLUMNS, ...
| 1 Replies | 2980 Views | Created by Mjsexton1 - Friday, July 27, 2012 7:41 PM | Last reply by GregGalloway - Sunday, July 29, 2012 6:55 PM

Isnumeric

isnumeric(left(ltrim(rtrim(@a)), 1)) + isnumeric(right(left(ltrim(rtrim(@a)), 2), 1)) + isnumeric(right(left(ltrim(rtrim(@a)), 3), ...
| 2 Replies | 806 Views | Created by Eldana - Tuesday, April 28, 2015 8:25 PM | Last reply by Kalman Toth - Tuesday, April 28, 2015 9:21 PM

isnumeric ...

Because, to the isnumeric function, it looks like a number. ( 0 = False, 1 = True)   IF you were to add commas in the appropriate locations to the ...
| 3 Replies | 6763 Views | Created by Gertus - Wednesday, April 18, 2007 4:11 PM | Last reply by Gertus - Wednesday, April 18, 2007 4:29 PM

Return \$var in function

Hello all, Having some problems with a script returning \$var from functions. I have the functions as the follow ...
| 7 Replies | 483 Views | Created by Arestas - Wednesday, August 19, 2015 6:17 PM | Last reply by Arestas - Wednesday, August 19, 2015 8:51 PM

ISNUMERIC() returns 1 for something that isn't numeric

By SQL Server's somewhat obscure definition, '1,2.1' is numeric.  ISNUMERIC() returns 1 if the passed parameter string can be implicitly converted to at least one of the numeric ...
| 5 Replies | 2031 Views | Created by GoodOldFashionedLoverBoy - Friday, March 22, 2013 10:19 PM | Last reply by GoodOldFashionedLoverBoy - Monday, March 25, 2013 3:09 PM

ISNumeric

I found the blog post where I found that: http://www.bidn.com/blogs/dustinryan/ssis/915/check-isnumeric-with-derived-column-transform-in-ssis-package Arthur
| 7 Replies | 5141 Views | Created by wifer87 - Friday, March 23, 2012 2:15 PM | Last reply by Sudeep Raj - Monday, March 26, 2012 11:57 PM

isnumeric question

Also, be aware that ISNUMERIC will return 1 for values that are technically numeric but may not be what you want. For example, ISNUMERIC('.') returns ...
| 4 Replies | 548 Views | Created by sqlguy10 - Sunday, October 1, 2017 3:56 PM | Last reply by Atif-ullah Sheikh - Monday, October 2, 2017 7:39 AM

IsNumeric

isnumeric() is a fairly useless function. It returns 1 if the value can be converted to any of the numeric data types  - int, float, money and decimal. If you ...
| 5 Replies | 2872 Views | Created by Elroacho - Wednesday, August 8, 2012 8:47 AM | Last reply by Naomi N - Sunday, August 19, 2012 7:26 PM

ISNUMERIC function

('+'), Isnumeric(',') and Isnumeric('.') all returns 1)However, You could use this ugly construct:select cast(cast('-' as int) as numeric)This will return 0.It ...
| 3 Replies | 8181 Views | Created by anandc - Tuesday, December 13, 2005 11:17 AM | Last reply by - Wednesday, December 14, 2005 2:05 PM

Bug with ISNUMERIC()

Hi BerzinP, As per the BOL:ISNUMERIC, ISNUMERIC returns 1 for some characters
| 8 Replies | 1538 Views | Created by BerzinP - Wednesday, July 8, 2015 1:00 AM | Last reply by --CELKO-- - Friday, March 4, 2016 4:52 PM

ISNUMERIC function

and the isnumeric is returning true. Is there any other way. to check if all the digits are numeric?   Thanks
| 7 Replies | 4595 Views | Created by ghankot - Friday, January 21, 2011 6:27 PM | Last reply by Adam_Turner - Friday, January 21, 2011 8:20 PM

Is anyone can help me for the Try_Cast or Isnumeric

ISNUMERIC is not the same as TRY_CONVERT(INT,..). You should be consistent if you don't want NULLs: Select Try_Convert(int,invoiceNumber) as IntAsINumber
| 3 Replies | 1337 Views | Created by regina2011 - Friday, December 9, 2016 5:01 PM | Last reply by Lin Leng - Thursday, December 15, 2016 9:43 AM

Sum and IsNumeric

is not numeric, besides isnumeric returns 1 for any numeric value and you need summary for value of 0 only.   Try the ...
| 6 Replies | 6366 Views | Created by JammingJ - Wednesday, February 27, 2008 8:46 PM | Last reply by David Dye - Wednesday, February 27, 2008 9:01 PM

IsNumeric Test

IsNumeric can help you in identifying whether a text can be converted into numeric or not. But raising error in the client side is not possbile in ...
| 16 Replies | 7361 Views | Created by FogHorn I - Tuesday, July 6, 2010 7:13 AM | Last reply by FogHorn I - Tuesday, July 13, 2010 1:47 AM

Dax Function, ISEMPTY, Question

>'EVALUATE ROW(“Any countries with count > 25?”, NOT(ISEMPTY(FILTER(Info, [Count]>25)))  << this is a SSAS MDX Syntax, it's not used for ...
| 1 Replies | 529 Views | Created by ResidentX10 - Tuesday, August 23, 2016 2:11 PM | Last reply by Emi Zhang - Wednesday, August 24, 2016 7:15 AM

IIF(ISEMPTY is Filtering out data MDX help

that helps, Richard Thank for the suggestion Richard, what I eventually ended up doing was creating a extra layer within the ETL ...
| 5 Replies | 1667 Views | Created by aivoryuk - Thursday, July 24, 2014 12:03 PM | Last reply by aivoryuk - Wednesday, January 7, 2015 10:43 AM