LIke in conditional split

Question

Post reply

LIke in conditional split

monali154

Valued Member

Points: 67
More actions
July 19, 2010 at 11:06 am

#224258

Hello All,
How do I evaluate below given expression in Conditional split in SSIS?
description like '[0-9]_%'+char(32)+'%' ??
Thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

PaVeRa22 SSCommitted Points: 1965 More actions · Answer 1

try...some thing like this...

SUBSTRING( «character_expression», 1, 1 ) >= 0

&& SUBSTRING( «character_expression», 1, 1 ) <=9

&& SUBSTRING( «character_expression», 2, 1 ) = "_"

&& SUBSTRING( «character_expression», FINDSTRING( «character_expression», «string», «occurrence» ), 1 ) = char(32)

RB

monali154 Valued Member Points: 67 More actions · Answer 2

Thanks,

Actually I tried this

(SUBSTRING([Copy of Description],1,1) == "0" || SUBSTRING([Copy of Description],1,1) == "1" || SUBSTRING([Copy of Description],1,1) == "2" || SUBSTRING([Copy of Description],1,1) == "3" || SUBSTRING([Copy of Description],1,1) == "4" || SUBSTRING([Copy of Description],1,1) == "5" || SUBSTRING([Copy of Description],1,1) == "6" || SUBSTRING([Copy of Description],1,1) == "7" || SUBSTRING([Copy of Description],1,1) == "8" || SUBSTRING([Copy of Description],1,1) == "9")

and it worked, it gave same results as query.

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

I don't see how - that expression looks only at the first letter of [Copy of Description] whereas your query does much more.

To me, yours looks equivalent to this:

(SUBSTRING([Copy of Description],1,1) >="0" && SUBSTRING([Copy of Description],1,1) <= "9")

clearly not the same.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

monali154 Valued Member Points: 67 More actions · Answer 4

Yes thts true they are not same,

Its just that i no more require to look for space(char(32)), only looking at first character solved purpose..

Thanks a lot!