Returns the date of the string parameter (M/d/y, M-d-y).
Query
Result
2012-08-02T00:00:00.000
Assertion : MDX Equals
Returns the numeric representation of the string parameter.
Query
Result
2.21
Assertion : MDX Equals
Returns the numeric representation of the string parameter.
As CSng is returning a float (32bits), its double representation (64bits) - used in icCube's engine - does not match exactly 2.21.
Query
Result
2.2100000381469727
Assertion : MDX Equals
Returns the integer representation of the string parameter.
Query
Result
221
Assertion : MDX Equals
Returns the integer representation of the string parameter.
Query
Result
221
Assertion : MDX Equals
Returns the string representation
Query
Result
221
Assertion : MDX Equals
Returns the string representation
Query
Result
False
Assertion : MDX Equals
Returns the string representation
Query
Result
false
Assertion : MDX Equals
Returns the string representation
Query
Result
145
Assertion : MDX Equals
Returns the numerical representation of its parameter.
Query
with
member v00 as Val( '10 Main Street' )
member v01 as Val( 'Main 10 Street' )
member v02 as Val( '10MainStreet' )
member v03 as Val( '34 10 Main Street' )
member v04 as Val( ' 34 10 Main Street' )
member v05 as Val( ' 34 - 10 Main Street' )
member v06 as Val( '075' )
member v07 as Val( '1,2 Main Street' )
member v08 as Val( '1.2 Main Street' )
member v09 as Val( '1 . 2 Main Street' )
member v10 as Val( '1.2e3 Main Street' )
member v11 as Val( '1.2 e 3 Main Street' )
member v12 as Val( '1.2 e -3 Main Street' )
member v13 as Val( '- 1.2 e 3 Main Street' )
member v14 as Val( '' )
member v15 as Val( null )
member v16 as Val( 1 )
member v17 as Val( 1.2 )
member v18 as Val('1 \t . 2 Main Street' )
member v19 as Val( 'ABC' )
member v20 as Val( 'ABC 1000' )
member v21 as Val( '1000' )
member v22 as Val( '+-1000' )
member v23 as Val( True )
member v24 as Val( False )
member v25 as Val( '1000' )
member v26 as Val( '1E3' )
member v27 as Val( '1000.0' )
member v28 as Val( '.123' )
member v29 as Val( '123.' )
member v30 as Val( '123.e2' )
member v31 as Val( '123.e' )
member v32 as Val( '123.e-' )
member v33 as Val( '123.e 2' )
member v34 as Val( '1234567890' )
select
{ v00, v01, v02, v03, v04, v05, v06, v07, v08, v09, v10, v11, v12, v13, v14, v15, v16, v17, v18, v19, v20, v21, v22, v23, v24, v25, v26, v27, v28, v29, v30, v31, v32, v33, v34 } on 0
from [Sales]
Result
v00 |
v01 |
v02 |
v03 |
v04 |
v05 |
v06 |
v07 |
v08 |
v09 |
v10 |
v11 |
v12 |
v13 |
v14 |
v15 |
v16 |
v17 |
v18 |
v19 |
v20 |
v21 |
v22 |
v23 |
v24 |
v25 |
v26 |
v27 |
v28 |
v29 |
v30 |
v31 |
v32 |
v33 |
v34 |
10 |
0 |
10 |
3410 |
3410 |
34 |
75 |
1 |
1.2 |
1.2 |
1200 |
1200 |
0.0012 |
-1200 |
0 |
0 |
1 |
1.2 |
1 |
0 |
0 |
1000 |
0 |
-1 |
0 |
1000 |
1000 |
1000 |
0.123 |
123 |
12300 |
123 |
123 |
12300 |
1234567890 |
Assertion : MDX Equals
with
member v00 as 10
member v01 as 0
member v02 as 10
member v03 as 3410
member v04 as 3410
member v05 as 34
member v06 as 75
member v07 as 1
member v08 as 1.2
member v09 as 1.2
member v10 as 1200
member v11 as 1200
member v12 as 0.0012
member v13 as -1200
member v14 as 0
member v15 as 0
member v16 as 1
member v17 as 1.2
member v18 as 1
member v19 as 0
member v20 as 0
member v21 as 1000
member v22 as 0
member v23 as -1
member v24 as 0
member v25 as 1000
member v26 as 1000
member v27 as 1000
member v28 as 0.123
member v29 as 123
member v30 as 12300
member v31 as 123
member v32 as 123
member v33 as 12300
member v34 as 1234567890
select
{ v00, v01, v02, v03, v04, v05, v06, v07, v08, v09, v10, v11, v12, v13, v14, v15, v16, v17, v18, v19, v20, v21, v22, v23, v24, v25, v26, v27, v28, v29, v30, v31, v32, v33, v34 } on 0
from [Sales]