Home » SQL & PL/SQL » SQL & PL/SQL » count of characters
count of characters [message #37925] Wed, 06 March 2002 19:17 Go to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
Hi,
I need to count the number of characters in a field.
ex: if Wdays char(7) is a field in Wtable and
Wdays = '1234'
how do i count how many characters are existing in Wdays field.

Thanks in advance
suresh

Report message to a moderator

Re: count of characters [message #37926 is a reply to message #37925] Wed, 06 March 2002 20:42 Go to previous message
Manoj
Messages: 101
Registered: August 2000
Senior Member
hi suresh,
use it.
select length(rtrim(Wdays)) from table

Report message to a moderator

Previous Topic: View and order by
Next Topic: Selecting rows using SysDate
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 19:06:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.