All Forums UDA
vgialelis 3 posts Joined 07/06
03 Jul 2006
SQL

Hello everyobody,I am totally new to teradata and my SQL background is also not so long. I will be working with TERADATA ODBC driver 3.03. I need to make a select based on a string field. All entries are strings ending with a special character which I was told is a new character....How can I write a select where I will filter out my entries? Something like:SEL descr FROM Table WHERE descr = 'my description\13'By the way. Is there a complete reference of all Teradata SQL statements with descriptions and examples?Any help is greatly apreciatedVasilis

RGlass 35 posts Joined 09/04
03 Jul 2006

Vasilis,sounds like you might use'like'select * from table where column like '%a%';or sel * from tablewhere colname like any ('%a%', '%b%');SQL reference found www.info.ncr.comTbob

vgialelis 3 posts Joined 07/06
03 Jul 2006

Thanks Tbob,but the problem is that I have entries in this field like:colname------------------'my description.\n''my description and some more.\n'.....so I can't use this statement:sel * from table where colname like 'my description.%' because it will return both rows in the example above....unless I do something likesel * from table where colname like 'my description.%' andcolname NOT like 'my description %' but it does not look so elegant...

dnoeth 4628 posts Joined 11/04
03 Jul 2006

Hi Vasilis,trySEL descr FROM Table WHERE descr = 'my description' || '0D'xc'0D'xc: "x" means a hex-string to be converted to a "c" character-stringDieter

Dieter

vgialelis 3 posts Joined 07/06
04 Jul 2006

thx Dieter, I will try this

giri 24 posts Joined 11/05
05 Jul 2006

hai The fact is that, we go for dimensional modeling insted on TNF is due to the limitations of the OLAP tools. teradata can perform effectively with the TNF table structure.

You must sign in to leave a comment.