[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Update SQL "my tekst" := "My tekst"

Posted on 2008-11-20
5
Medium Priority
?
368 Views
Last Modified: 2012-05-05
Hi,

Database = MS Access
I want to update a field based on a second field. In the updated field the first character of the string must be changed to UpperCase.

Field1= my tekst
Field2= My tekst
Update Mytabel set Field2 = UppercaseFirstChar(Field1)

Can anybody give me an example on how to do this?
0
Comment
Question by:Stef Merlijn
  • 3
  • 2
5 Comments
 
LVL 18

Assisted Solution

by:jmoss111
jmoss111 earned 2000 total points
ID: 23002855
Hello Delphiwizard,

UPDATE MyTable
SET FIELD2 = UCASE(LEFT(FIELD1),1)


Regards,

Jim
0
 

Author Comment

by:Stef Merlijn
ID: 23002870
Will this copy the whole string from Field1 into Field2 or only the 1st character?
0
 

Accepted Solution

by:
Stef Merlijn earned 0 total points
ID: 23002882
This is the whole SQL statement.
UPDATE Relaties SET Adressering = UCase(LEFT(TAVvoorBrief,1)) & MID(TAVvoorBrief,2,199);
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 23002920
Delphiwizard, I was still asleep I guess and I have no objection.

Have a great day,

Jim
0
 

Author Comment

by:Stef Merlijn
ID: 23002929
You're welcom...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

873 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