Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

character count

Status
Not open for further replies.
Cornelius19

Cornelius19

Technical User
Mar 9, 2007
26
Hi,

I have a column containing words and would like to count how many times each character occurred. There are some non-ASCII characters. Do you have any idea how to do this? Is there an SQL query or would it need a (VB) Script?

Thanks,

Cornelius
 
Status
Not open for further replies.

Similar threads

ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
191
gk53
gk53
NickyJay
  • Locked
  • Question
sp to count files inside x number of dir's inside one dir??
Replies
2
Views
49
mrdenny
mrdenny
Kraeg
  • Locked
  • Question
mySQL to SQL Server 2000 DTS character problem
Replies
0
Views
38
Kraeg
Kraeg
manmaria
  • Locked
  • Question
COUNT in SSIS look
Replies
1
Views
19
manmaria
manmaria
jpotucek
  • Locked
  • Question
Create output to a Character delimited .csv file
Replies
1
Views
27
JayKusch
JayKusch

Part and Inventory Search

Sponsor

Back
Top