How to count the "number of character"?
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Analytical Applications » How to count the "number of character"?
This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


How to count the "number of character"? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Benjamin See
Posted 10/12/2007 4:41:02 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 8/20/2008 6:42:37 AM
Posts: 48, Visits: 20
Dear Who Know How,

Let say I have a table as below:
*********************************
PRTY_ID_NUM
L597921
761212-06-5364
*********************************

Can I use SQL to count the number of character for each variable?

The Result should be:
L597921=7
761212-06-5364=14

Many Thanks in Advance. ^_^

Regards

BS
Post #9212
Balamurugan B
Posted 10/12/2007 5:09:12 AM
Forum Guru

Forum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum GuruForum Guru

Group: Forum Members
Last Login: 10/15/2008 10:54:22 AM
Posts: 56, Visits: 68
Hi Benjamin,

You can use Character_length() function to count the no of characters.

For your example use the following query:

select PRTY_ID_NUM, character_length(PRTY_ID_NUM) from table_name;

Result will be:
PRTY_ID_NUM -- character_length(PRTY_ID_NUM)
L597921 -- 7
761212-06-5364 -- 14


Regards,
Balamurugan
Post #9213
Benjamin See
Posted 10/12/2007 5:19:04 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 8/20/2008 6:42:37 AM
Posts: 48, Visits: 20
Dear Balamurugan,

Thank you very much!

Cheer! ^_^

Regards

BS
Post #9215
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 1 ( 1 guest, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 4:11pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 7 queries. Compression Disabled.