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
Lenovo Support Drivers Wrote:
2:e Augusti 2017
This is a beautiful and informative post. Keep it up dear. Lenovo Laptop Customer Support
Epson printer tech support Wrote:
17:e Augusti 2017
Thanks for sharing your valuable features and other relevant information. Epson Phone Number Epson Printer Problem
http://www.ourneighbourhoodplanning.org.uk/forums/thread/259/EPSONPRINTERSUPPORT1-844-653-7999EPSONSUPPORT
michaelthomas Wrote:
3:e Oktober 2017
Thank you for sharing this post.. Dell Printer Help Number UK Dell Printer Helpline Number UK Dell Printer Support Number UK
Talisman Wrote:
3:e December 2017
Thanks a lot for sharing. You have done a brilliant job. Your article is truly relevant to my study at this moment, and I am really happy I discovered your website. 192.168.0.1
Roadrunner Email Customer Service Number Wrote:
6:e April 2018
If you forget the password of your Roadrunner mail you can recover it through your phone or an alternative email id. You need to answer the security question too if still, you are not able to get it. Roadrunner Email Support Number Roadrunner Email Helpline Number Roadrunner Email Phone Number
Iodine Wrote:
30:e Maj 2018
It is extremely nice to see the greatest details presented in an easy and understanding manner. Iodine
Fennel Wrote:
30:e Maj 2018
I have to search sites with relevant information on given topic and provide them to teacher our opinion and the article. Fennel
Nutmeg Oil Wrote:
30:e Maj 2018
You have done a amazing job with you website Nutmeg Oil
Norton Customer Support Wrote:
23:e Juli 2018
i have no word for this website & outstanding posting..Norton Customer Service
josef Wrote:
21:e Augusti 2018
I really like your article. I had many useful things from this article. i really appreciate your efforts linux hosting with cpanel godaddy for write this post. Thanks for shearing that informative post with us.
Albert Richard Wrote:
23:e Augusti 2018
Kaspersky is a protection tool providing security to all the systems around the globe from all types of malware, spyware Trojans, and viral attacks. In order to get Kaspersky free of all technical errors to ring the technologist at Kaspersky Phone Number UK.
Stephen L. Estes Wrote:
31:e Augusti 2018
Wonderful article, i like reading the content which you have posted.You have done an excellent job. business cards printing
Minna Wrote:
11:e September 2018
Wow,I simply want to tell you that I am new to weblog and definitely liked this blog site. Thanks Again. Keep making. I like it. http://www.gurgaonescortsfun.com/ http://minna.in/
HP Laptop Support Number UK Wrote:
15:e September 2018
your post is good many people like , and I am also providing some services about antivirus you can try this, Call HP Laptop Support Number UK @ 0800-014-8456 toll free for HP Customer Support UK, HP Laptop Helpline UK, HP Laptop Phone Number UK, HP Support UK, HP Laptop Contact Number UK. Our Technical team will guide you 24/7 hours.
Techsmith Snagit Coupons Wrote:
12:e Oktober 2018
Hello, Extremely amazing this imperative settlement is to a Snagit Coupon Codes awesome degree surprising and remarkably obliging for my control many thanks and sorry for my underwriting to set up everything here.
Johny Parkar Wrote:
15:e November 2018
AVAST, AVG ,Norton or McAfee antivirus which is regarded as one of uppermost antivirus across the globe and simultaneously protects compatible devices from dangerous malwares and viruses. Don’t worry we have top notch solution provider as our Avast antivirus technical service is available 247365 if one faces error for this simply be connected with our toll-free number+1-844-534-8410. There are multiple operators who proffer solution for entire technical issues faced with avast antivirus. We are one of best Avast,AVG,Norton or McAfee antivirus service provider to clarify each and every issue within stipulated time period.
Albert Wrote:
26:e November 2018
I am glad to see a piece so well written with all the necessary details and information, keep posting more. Avg Support UK & Avg Contact UK
Harry Smith Wrote:
26:e Februari 2019
Thanks for posting this informative content here, it helped me a lot and will surely a lot of other people as well. McAfee Support Number UK McAfee Contact Number UK
mickeymouse Wrote:
3:e Oktober 2019
SAJ Real Wrote:
28:e November 2019
Thanks for sharing your valuable features and other relevant information. So please visit our website for real estate problems.