#DateForumTypeThreadPost
1715 Oct 2014 @ 07:02 PDTDatabaseReplyRemove Chars and get only numeric valuesgreat, Thanks a lot. :)
1614 Oct 2014 @ 10:45 PDTDatabaseReplyBad Data Formattry converting it into string and using subtring function get the required number of chars and then convert back it into int and apply Sum. try something like or around this. hope it works, all th...
1514 Oct 2014 @ 10:41 PDTDatabaseReplyRemove Chars and get only numeric valuesSource column is having a string value like 'AL234ps12w' and i need the output without characters, that is only numeric values 23412 as the output value to be stored in target column.
1414 Oct 2014 @ 06:14 PDTDatabaseTopicRemove Chars and get only numeric valuesHi, I need to remove all the chars from an alpha numeric string ('AL234ps12;') to get 2342 as the result or fetch 2342 from the an alpha numeric string ('AL234ps12;'). could anyo...
1325 Aug 2009 @ 03:37 PDTUDATopicHow to get the position of special char in a string?How to get the position of special char in a string?I need to convert the string given below under type A into Type B.Type A Type B'Jiby Jose' 'Jiby''Jiby: Jose' 'Jiby''Jiby?: Jose' 'Jiby''Jiby(A) ...
1225 Aug 2009 @ 03:13 PDTDatabaseTopicHow to get the position of special char in a stringHi all,How to get the position of special char in a string?I need to convert the string given below under type A into Type B.Type A Type B'Jiby Jose' 'Jiby''Jiby: Jose' 'J...
1103 Aug 2009 @ 10:02 PDTDatabaseReplyHow to check if data is in upper case or notHi Dnoeth,I was provided a table with millions of records of data and lots of business rules on which this table was built.I need to validate the table against those business rules and one of the b...
1003 Aug 2009 @ 09:56 PDTDatabaseReplyHow to check if data is in upper case or notHi Pawan,this is working great for me.Thanks a lot.
931 Jul 2009 @ 09:10 PDTDatabaseReplyHow to check if data is in upper case or notHi Adeel,When I am trying to compare the strings 'venkat' and 'VENKAT', teradata is showing that both are same.I want the output that both are not same.select 'venkat' as sname, 'VENKAT' as uname, ...
831 Jul 2009 @ 05:28 PDTUDAReplyto get datatypes of all column from tableHi Adeel,I have added a new topic 'how to check if data is in upper case' in 'Teradata Database'.Please reply. Thanks & Regrds,Venkatesh G
731 Jul 2009 @ 05:19 PDTDatabaseTopicHow to check if data is in upper case or notHi all,I need to check if data in a column is converted from to upper case or not.Please help me in this regard.venkatesh.gubba@gmail.comThanks & Regards,Venkatesh G
608 Jun 2009 @ 05:31 PDTDatabaseTopicRounding down 2.50 to 2Hi Adeel,I have an issue with rounding the decimal to nearest integer.if value = 123.45, I need to round it to 123if value = 123.54, I need to round it to 124I have achieved this with the cast(123....
508 Jun 2009 @ 05:24 PDTDatabaseReplyRounding Down in TeradataHi Adeel,I have an issue with rounding the decimal to nearest integer.if value = 123.45, I need to round it to 123if value = 123.54, I need to round it to 124I have achieved this with the cast(123....
418 May 2009 @ 06:16 PDTConnectivityReplyhow to search for char ' and remove from the string "venkat's house"its working Thank you
318 May 2009 @ 05:53 PDTConnectivityReplyhow to search for char ' and remove from the string "venkat's house"I need to replace the 's with si need to remove ' (all the instances)I am using the following query to find the index:select index(contr_titl_nm,''s')FROM usp_sls_contr_obvw.contrwhich is wrong,ple...
218 May 2009 @ 05:38 PDTConnectivityReplyHow to use cursors in UDFI delected the question and created new question, could you please answer my question?
118 May 2009 @ 05:32 PDTConnectivityTopichow to search for char ' and remove from the string "venkat's house"Hi,Please let me know how to search for the character ' in a string and remove it.data we have in teradata is "venkat's house"i neet to remove ' and convert it into "venkts house".please help me in...