Ta bort mellanrum och tab-tecken från databas-värde
Jobbar med en databas där jag för länge sen hade importerat emailadresser från Excel eller liknande, kommer intee ihåg nu.
Märkte dock att det var massa tomma spaces efter själva emailadressern och letade efter ett sätt att ta bort dem. Detta svar kändes ju eom en bra lösning.
UPDATE [User] SET Email= LTRIM(RTRIM(Email))
Mellanrum kvarstod dock och då funderade jag istället på om de kanske var tab-tecken. Mycket riktigt efter ett tips så kunde jag köra det som behövdes.
UPDATE [User] SET Email=REPLACE(Email,char(9),'')
Comments
jolly Wrote:
31:e Maj 2016
this post is really good. thanks for this post. http://www.onlinepromotionuae.ae"> http://www.onlinepromotionuae.ae
jolly Wrote:
30:e Juni 2016
nice post..... www.andamandiscover.com"> www.andamandiscover.comlink text
jolly Wrote:
1:e Juli 2016
thanks for sharing a nice post... http://onlinepromotionhouse.com"> http://onlinepromotionhouse.comlink text
Jennifer Smith Wrote:
21:e September 2016
Superb Idea, I totally accept this post seriously. Keep it up. Call for Lexmark Printer Customer Service Phone Number 0800-014-8577(toll free UK) and get Lexmark Printer Support, Lexmark customer service, Lexmark printer help, Lexmark printer technical support, Lexmark printer technical help etc. Our team is ready to provide help 24/7.
jon mark Wrote:
1:e Oktober 2016
Having a printer of HP solves out all your problems related to printing, copy and lots more. But what will you do if suddenly it stops working? You can get in touch with our executives from HP Printer Support Number UK and get resolution for all your problems.
Canon Printer Support UK Wrote:
15:e Oktober 2016
You will get to see many teams who offer you support for Canon Printer issues but few are genuine who will resolve your issues in a while. We are one of those who are always ready to provide you support and to seek assistance from our experts call at Canon Printer Contact number UK. 0800-098-8356
Dell Printe Support Numbe UK 0800-098-8371 Dell Printer Help Number UK Wrote:
3:e November 2016
Awesome Post.. Nice Content.. Thank you for sharing..Facing technical issues in installation of the Dell printer, Call us at Dell Printer Support Number UK. Our expert will help you to solve these issues.
Acer Contact Number UK 0800-098-8371 Wrote:
5:e November 2016
Great blog! I really love how it is easy on my eyes and the information are well written. Acer Helpline Number UK I am wondering how I might be notified whenever a new post has been made. I have subscribed to your feed which really should do the trick! Have a nice day!
microsoft customer support Wrote:
7:e Januari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed
Microsoft Customer Support Number
Gmail Helpline Wrote:
7:e Januari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed
Gamil Support Number
Mcafee contact number uk Wrote:
7:e Januari 2017
this is outstanding and great post! i really like it. thank you so much
Mcafee support uk
Aleena Wrote:
7:e Januari 2017
Great info.. your content very helpful.. Thank you for sharing.. We Provide Technical Support for Kaspersky Antivirus more help visit here : Kaspersky Help Number UK Kasersky Contact Number UK kaspersky Support Number UK
microsoft support number Wrote:
10:e Januari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed
microsft support
avast online security Wrote:
16:e Januari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed.
Avast Technical Support Number
toshiba laptop support uk Wrote:
16:e Januari 2017
thanks for this awesome web page, i like it
toshiba support uk
hp support Wrote:
23:e Januari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed. hp printer support
Toshiba tech support uk Wrote:
23:e Januari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed. Toshiba tech support uk
Norton technical support number Wrote:
23:e Januari 2017
This is outstanding and great post! i really like it. thank you so much. Norton technical support number
kaspersky support Wrote:
23:e Januari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed.
epson support Wrote:
23:e Januari 2017
thanks for this awesome web page, i like it Espon printer support number
Microsoft Windows Help Wrote:
25:e Januari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed. Call@ 0800-098-8569 for Windows Support Number, Windows XP support, Windows 10 Support, Windows 8 help, Windows Phone Support, Windows Tech Support, Windows 7 Support.
Windows Support Number
microsoft support Wrote:
31:e Januari 2017
thanks for this awesome web page, i like it Microsoft Help Number
hp support Wrote:
1:e Februari 2017
Today I learned a lot from your website. thank you hp support
Windows Support Wrote:
1:e Februari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed.Call@ 0800-098-8569 for Windows Support Number, Windows XP support, Windows 10 Support, Windows 8 help, Windows Phone Support, Windows Tech Support, Windows 7 Support.
Windows Support Number
avg customer support Wrote:
1:e Februari 2017
we are offered new latest support for kaspersky support number. avg customer support
peter236 Wrote:
2:e Februari 2017
this post is extremely good so keep posting further thank you so much. Call@ 0800-098-8613 for any issue related to yahoo help, yahoo change password, yahoo problems yahoo support, yahoo email settings, etc.
peter Wrote:
3:e Februari 2017
Hii, Thanks for the sharing nice posting with us. i’m really impressed. Epson printer helpline number,
epson helpline Wrote:
4:e Februari 2017
Today I learned a lot from your website. thank you epson helpline
peter smith Wrote:
6:e Februari 2017
I learned a lot from your website. thank you for this article to know about it and this is supportive information another services you want visit here..outlook support, outlook support number...
Hotmail Technical Support 0800-098-8613 UK Toll-Free Contact hotmail Wrote:
7:e Februari 2017
Today I learned a lot from your website. thank you Call us Our Toll-free 0800-098-8613 UK for any set up a hotmail account, reset hotmail password, Hotmail Support Number, Hotmail Helpline, Hotmail support. click here.. Hotmail Technical Support Number
Toshiba Wrote:
14:e Februari 2017
I feel myself very lucky for being on this site. Each and every series what you take for us are awsum. you are very humble to users. You update everything here for your readers. Thank you.
Toshiba tech support number
hp printer helpline Wrote:
14:e Februari 2017
this post is really good to read and i also like it so thank for the posting this type of story.
HP Printer helpline uk, HP Printer technical support number uk
Lenovo help Wrote:
15:e Februari 2017
I feel myself very lucky for being on this site. Each and every series what you take for us are awsum. you are very humble to users. You update everything here for your readers. Thank you.
Lenovo help
Norton technical support number Wrote:
15:e Februari 2017
I feel myself very lucky for being on this site. Each and every series what you take for us are awsum. you are very humble to users. You update everything here for your readers. Thank you.
Norton technical support number
Toshiba contact number Wrote:
15:e Februari 2017
I feel myself very lucky for being on this site. Each and every series what you take for us are awsum. you are very humble to users. You update everything here for your readers. Thank you.
Toshiba contact number
Lexmark Printer Customer Support Wrote:
18:e Februari 2017
I feel myself very lucky for being on this site. Each and every series what you take for us are awsum. you are very humble to users. You update everything here for your readers. Thank you.
Lexmark Printer Customer Support
Espon printer customer support Wrote:
18:e Februari 2017
Very Very nice post. its a very useful and outstanding article. Thanks for that. epson support number
bt broadband help Wrote:
20:e Februari 2017
thanks for this awesome web page, i like it. Bt Broadband Help
Canon support Wrote:
22:e Februari 2017
Very Very nice post. its a very useful and outstanding article. Thanks for that.
Canon Printer Customer Service
Jocob black Wrote:
23:e Februari 2017
What to do when Norton antivirus is not completing the task to protect your system or working slow? The answer is to dial Norton Customer Care Number UK and get the correct resolution to remove the hurdles but the expert technicians. They can resolve every kind tech issues in a short while.
peter william Wrote:
23:e Februari 2017
i loved this article and this is so awesome post so thanks to this article. network solution contact
peter orther Wrote:
27:e Februari 2017
i loved this story so thanks for the posting this article. canon service center number
Toshiba Laptop Support Number Wrote:
27:e Februari 2017
I feel myself very lucky for being on this site. Each and every series what you take for us are awsum. you are very humble to users. You update everything here for your readers. Thank you.
Toshiba Laptop Support Number
Epson Technical Support Wrote:
14:e Mars 2017
Its very useful post for me, I like your post and all you share with us is up to date and quite informative. Epson Printer Help Number UK Epson Printer Support Number UK
Hp printer support Wrote:
20:e Mars 2017
Very Very nice post. Hp printer support
Hp printer support number
network management system Wrote:
29:e Mars 2017
Its very useful post for me, I like your post and all you share with us is up to date and quite informative. network management system
Alex Wrote:
1:e April 2017
Hey. What a helpful post. Thank you for sharing. We provide the best technical support for Canon printer. Canon Printer Support Number UK Canon Printer Help Number UK
Avast help number UK Wrote:
10:e April 2017
Avast support number UK
Avast help number UK
software support Wrote:
15:e April 2017
This is really very nice blog and so informative. Thanks a lot for sharing this article.
microsoft phone number
software sales services
Cavin Wrote:
21:e April 2017
Among the various manufacturers of printers, HP has been on the top of this criterion and offers a wide range of reliable printers. Yet, however these printers become unable to perform best due to technical issues and toe resolve that you must get connected with the technicians of Hp printer contact number UK at 0800-090-3228
printer support Wrote:
27:e April 2017
Hi, Thanks for the sharing nice posting with us.i’m really impressed.Take a look at my page. printer support number
Mcafee Antivirus Helpline Wrote:
27:e April 2017
this is awesome & great post,
Contact McAfee Antivirus Support
Marian Smith Wrote:
17:e Maj 2017
Guys, wonderful post to never let us run out of ideas…! Canon Printer Support Number UK Canon Printer Contact Number UK
Marian Smith Wrote:
17:e Maj 2017
Guys, wonderful post to never let us run out of ideas…! Canon Printer Support Number UK Canon Printer Contact Number UK