Uppdatera databasfält till inledande versal följt av gemener

Vi hade en databas med massa postorter i versaler (ALINGSÅS, GÖTEBORG, STOCKHOLM) osv men ville ha dem så här istället (Alingsås, Göteborg, Stockholm).

Hittade tips i ett forum hur man gör.

Först för en SELECT för att testa:

SELECT UPPER(left(CityName, 1)) + substring(LOWER(CityName), 2, LEN(CityName))  FROM [Cities]

Och sen en UPDATE som ändrar fältet:

UPDATE Cities SET CityName = UPPER(left(CityName, 1)) + SUBSTRING(LOWER(CityName), 2, len(CityName))

Comments

I am going to share with you, some my college life memories. When i was in my last semester in my bachelor degree class, i was confused to face the world because i don't now the results and future as well. Now i am here to tell you that, in these days students are more comfortable and easy to get educational help.

thanks for shearing with us. http://www.onlinepromotionuae.ae

Great Post, in case you require any help in resolving any technical issue in your Epson printer you can immediately call the experts at 0800-098-8371 Epson Printer Help Number UK.

we are offered new latest support for hp printer support number. epson printers,

Hii, Thanks for the sharing nice posting with us. i’m really impressed.

thanks for share this type of idea avast support phone number

Please fill out all the fields.

*
*