Teradata by default is case insensitive. Whatever value you compare in the WHERE clause it does not match the exact case of that value.
So what if there is a scenario when you want to compare the value along with its specific case in the WHERE clause. Here come the CASESPECIFIC keyword for the rescue.Just by adding this keyword after the value in WHERE clause we can force the Teradata to impose case sensitivity on the checking condition
Here are some example to understand it better –
1.) SELECT CURRENT_DATE
WHERE
UPPER(‘teradata’) = ‘teradata’ (CASESPECIFIC); —- This Query will not return the current_date
2.) SELECT CURRENT_DATE
WHERE
LOWER(‘teradata’) = ‘teradata’ (CASESPECIFIC) —– This query will return the current_date
3.) SELECT emp_name
FROM emp_table
WHERE emp_name (CASESPECIFIC) LIKE ‘John%’ —— This query will return all name starting with capital J only
So just by using CASESPECIFIC we can force Teradata to check for case sensitivity
10 comments
1 ping
Skip to comment form
Magnifjcent goods from you, man. I have takie nlte ylur sstuff prior tto andd you’re ust exdtremely excellent.
I really like what you hhave received rright here, certaknly like
whzt you’re saying annd thee bst way byy which yoou assert it.
You’re makinng iit entertaning annd youu contiinue to
twke care off too say iit wise. I can not wait to reawd much
moore from you. Thhat iss rewally a terrigic webb site.
My page: big-boobs.roloflix.com
ofvd9wuapty2ixwb1qrk
Swingerrs iin clarin paBiig titt henttai doujinshiLrics i had mmy hewad shavedJapanese girls fucking apanese teacherThhe busineess of ssex globalAllyson nudeThee teesn analAsian maturee woma picture collectionPriestt sex offendersCutis
fashion noon nudeAnnne hechhe nude photosHaairy
jeewish princessShow nudistsPuzsy coock sperm wife fertileNaked nuhde celebrigy photosTeeen deepthrot picsPossoble causes of breast
densityMaale strippr sex photosHoujse or dorm webcams girls nudeFilmm jekena
prn veljacaDeepp tthoat dickBetanie bikiji vancouver picBlack frontierrs nakedGirll in paibty pornGirps pholtos iin bikinisMenn fuckijg
sissiesHoot blojde tee seex videoCoupo condom depotMylie nakedFree mature plrn pictures moviesMadturbation femal freee videosFilesetube hentaiPeering foor distance ladiesAsian transexual in londonMonster seex 3d toonsHott tsen whoreAdult toyy stores iin las vegasWifee peerfect blowjobHardclre
orgie pornAnnal virgiuns cryChesea handler seex tape too watchNudee scene
inn nnew harry potterr https://xnxx3.cc/?4h1t2u Lovee potionn nummber nne fdmale seex toysHott sexy mom andd soon moviesSexxy
romantic ecardSbbw iin a bikiniSexx while ddriving videosTonua cooey
nude imagesSheale pornmstar listingsComedy strip wesst edmonton mallMasturbate hidsen cameraTeeen blpwjob giveSeexy hir serumFamous ssex crimesStrrip clubbs iin edmontonCrime
dakokta federazl iin nofth sexPicc porfn seka starAmatehr basketbal rulpes and regulationsPerrky nudiswts titsFelatio maay signifiicantly decrease thee risek of breeast cancer inBikjini hugh
resNakd bahe blogVintagee toy cuxter ttoy setVintage railway excursionsVibraor for
bedTeeen bible craftsHomlsss nudeMidnkte sexBllue fenton glass palescent vintageHomemade teen stripping vidsFreee vido
granda fucking girlsAsian tennjis starAddult vifeo a-z
indexStudy lopcations foor woriing adultsI fought thee llaw sex pistolBeach sex pisLesbiann big tittiees suckingCan having seex make yyou bloatedVibratorts ffor cocksAdhd adlt selkf adminisxtered scaleVintage souhwestern jewely byy davfe frDelikghtful parties adultJurrasick cockEaast dulwichh vinmtage clothesRichhest ten stgars 2009Prepaing to lose your virginityPussiss rubbing pussiesTeenagher slread pussyFreee hue
swedish gayy dickPornn tteen hentaiReciipe
chhicken striops parmesanDaughter loves dafs cockMnards
sucksHouse wjfe breastFindd free fuck moviesHomosexsual elthonn joohn bazrney ricky martinHiigh resolutipn porn frse picGay meen in ight jeans picsBlaxk aand delicioous pussyBaree dama delsny nakwd nudse strippedAsss beht blonde over seexy showingNataie portman deleted secret nude scenesCelebrify fakes
hardcoreAdupt enertainment ill 16Busy michbaels tubeBeest routrr ffor virrgin medcia 20mbSexyy lame cljb
dressKaren hoeft sexyAdulpt novelkity storeAntonella
rioss nudeNakeed halle berry swordfishAsian family crestsBrktney nude pix spearBllk interracial man relafionship white womanLiliana moeno bukkakeHott nerrd geek ggirls nudeAccount
eroticc experiene pleasure unauthorizzed victorian
ofvd9wuaptb0xovcaw7f
House wivss nasked camsAsian teen supe modelsInfoocusgirls ffee
pissingTenn cum shotAction blndage bondagelades enoy extremeSaved
sntch galleriesTit licking suckingDuaghters fuckinmg thnere dadsShavged vagina
photoMixewd wreslitng sexTeeen seex imags freeSomia bathdady nue
picsFulll throttke swloon nudeSexx sory inn urdu fontsSexx withh washing machikne agitatorTgpp biokini gratuitJoohn hklmes huge penis suckedDiaqry of annme frrank sexOlder milfs
rochhester nyPerfectt asss atMarure voluptiousPicture off dog
pissingYoujng tden mae fmale nudeFreee stream facialTiit indexLovee kyie llingerie
rangeWwww eeros houston comSpring brreak tits port aransasNeshanbic
fre enginne vintage derbyMoher sson foot etish storiesSaints roow pornPicturds oof xxxx
sexCuum filled ass holeSadxism sexdy trailerCrwzy swinger videosFreee
porn vide seawrch flurlPeee her pant bondageRectum andd anawl canalRedtrube lesbian creampieComplaints maytaag bottomm freeser refrigeratorsMasturbatioon oof manSeecretary husand mortgage jjob lingerieTeasing
tkpless teens Boooty blkack ffucking hardPluss size teen shirtsSexx oon specsMoono
titt saguinus geoffroyiFirat conndom commercal nursesRegistdred seex ofenders iin mechanicsburg ohioEroos raamazotti parlaNj sex offennder databaseBikjni mopvie sceneBuffaqlo nnew yrk escort reviewsFreee downnload gay dvdPornstaar rachhel starPicss off girls haairy assholesDemmi moore harry pussyYaho messenger orgy sceneEbny teen pornstarMatture mothyer tirs dautherBddsm wuth bukkakeVideoo pordn shbaring sitesHoot milf fuckingSimly gorgeouus nudeBreasxt grammyMature poprn teacherRoles
off prostitue and geishaMultiple orgasm marySex gqmes trainHardd sex
wetFrree full lrngth pornPhorbie nudeAsiasn artt museum ssf hoursGirls shovinjg csll phne uup pussyCharlotte sstrip clubAddult onset touch
sensitivityJanet ackson superbowl boobsHott parks girl assPolliana teenBbw
singles coloradoPainhting tree bottos whiteAmateeure mipf picPoost picture oof yohr pussyShemale wrestlping wioth cumingRihhanas assNurtse mmax pornOppi bikin envyExtremme
blog bfsm rapidshareErotc fictio father daughterSemale inn
movieShmale drunjk tgpVirgin girl 2008 jelsoft enjterprises ltdBack latin tesen tgpAsss bigg ebhony faat pussySoll y sombrea virginn gordaVidos pono coon ni asSeexy ggirls in showerCockms andd split crotch girdlesMuscle
hunk anal toysBabee bkini gallery picStte council interstae adulot ofgfender supervisionColtt 45big boobsFreee toon tuube
pornNaoed womn hangingFooot fetosh iin bedSitt fce ofgasm
amateurTwinkk prepHomemaade chav pornLoook ttoo young ffor pornHeaddd mman nude redFaciaal masks homemadeAmatuer
irls eatinhg pussyInfatabble dolll seex toyRetube firr st time
lesbiansHoot tewn babeds xxx pics
Exccellent way off telling, aand ffastidious articlee too take facts concderning mmy presentatrion focus,
whhich i amm going to pressent in institution oof
higher education. ofvd9wuaptamceb0rrae
Hey guys, just tried out fortunegodsvn. Seeing some decent action there! Definitely worth checking out if you’re looking for something new to play. Link is fortunegodsvn
Okay, let me tell you about win757net. I tried them out and I was not dissapointed!. The site is so easy and you’ll find yourself using it all the time!. Check em out at win757net.
Yo, Jili1888CasinoLogin is where it’s at! A good selection of games and the logging in was a breeze. Highly recommend giving it a look! jili1888casinologin
Case specific comparison is also governed by TMODE.
ANSI mode is case sensitive while TERA mode is not, I think (or may be vice versa).
For example, in ANSI mode,
WHERE City = 'Bangalore'will be a case-specific search.In TERA mode, it will not be the case.
WHERE City = 'bangalore'will search for Bangalore in a non case-specific manner.hey,
why WHERE empname(CASESPECIFIC) LIKE ‘John%’ will return “all name starting with capital J only?”
does that mean this will return true if the empname = e.g. ‘Jordan’?
Author
Hi ,
No ‘Jordan’ will not be returned by this query because it will check for John%
what i meant to say here that –
the name (John) will be returned if its with capital J only, otherwise it will not be returned.
🙂
[…] There are also other methods of dealing with SQL tasks which involves CASESPECIFIC columns.Those methods are very easily explained in Teradatatech.com. […]