Solved

@propercase to change fields in a dB

Posted on 2006-07-05
4
228 Views
Last Modified: 2013-12-18
I have a db that has the city and county that are all uppercase, I know I can use an agent to change the fields to propercase.

So I wrote the following very quick and easy agent, now as you can tell development is not only NOT my forte but I never ever do it!

@ProperCase (County);
SELECT @All

However, when I run it against forms it does nothing I am sure I am missing something, I want it to replace the Word SUFFOLK in the field County to Suffolk.

Thanks,
Michael
0
Comment
Question by:mwebb_sdmc
  • 2
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
CRAK earned 250 total points
ID: 17045380
Try:

Field County:=@ProperCase (County)
0
 

Author Comment

by:mwebb_sdmc
ID: 17045397
That doesn't change the field.
0
 
LVL 13

Expert Comment

by:CRAK
ID: 17045427
This is still the agent?
Is it running on e.g. selected documents?
0
 

Author Comment

by:mwebb_sdmc
ID: 17045481
Yes that is correct.  Agent running on select set of documents.  Oops works I spelled it incorrectly county = country works now thanks..
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question