Error converting data type varchar to Float.

By
roopesh.valluru
-
427
17194

Friends,

Sometimes you need to convert the data of a column in SQL server table from VARCHAR(String) to FLOAT. When I was working on the similar one today i got an error saying that

Msg 8114, Level 16, State 5, Line 2
Error converting data type varchar to Float.

PFB the code I have written  –

SELECT col1, CAST(col2 AS FLOAT) as col2 FROM #DaTable

I was getting this error because there is some data like NULLS and non numeric values which cannot be converted to FLOAT datatype. To handle this kind of error we have to use the CASE Statement. PFB the converted code which converts VARCHAR column to FLOAT column.

SELECT col1,  
	CASE WHEN ISNUMERIC(col2) = 1
		THEN CAST(col2 AS FLOAT) 
		ELSE NULL 
	END as col2
FROM #tableName

In the above example at first point I am checking whether the data is NUMERIC or not using ISNUMERIC() function and if the data is non numeric then I am replacing the value with NULL as I cannot convert it to FLOAT type and then casting the data ONLY when it is NUMERIC to FLOAT.
Hope this helps !!
Regards,
Roopesh Babu V

RELATED ARTICLESMORE FROM AUTHOR

427 COMMENTS

  6. Preload NE recruits cardiac preload reserve and reduces preload dependency in patients with septic shock buy priligy in the us Curcumin promotes the down regulation of NF ОєB in multiple myeloma cells 11, which results in activation of caspase 7 and caspase 9, and induces polyadenosine 5 diphosphate ribose polymerase cleavage, culminating in apoptosis

  9. In the univariate analysis, the rs9282861 genotype was not associated with any differences in survival among patients who were given adjuvant radiotherapy but no adjuvant chemotherapy or hormonal therapy n 230 cialis price How Concerned Should I Be About Black Widow Spiders

  17. [url=https://propecia1st.science/#]order generic propecia without prescription[/url] buy cheap propecia without insurance

  49. buy zithromax online with mastercard [url=https://azithromycin.men/#]zithromax buy online[/url] buy generic zithromax online

  55. We could speculate that a combination of these factors could contribute to why G361 does not respond to DRE treatment, and by eliminating these factors, we could possibly determine how DRE might therefore act in A375 human melanoma cells viagra priligy Shinjo SK BonfГЎ E Wojdyla D et al

  75. mail order pharmacy india [url=https://indiapharmacy.cheap/#]Online medicine home delivery[/url] Online medicine order

  85. Casino.org. “Casino House Edge Explained.” The £1 minimum deposit casinos are online gaming platforms that allow you to play by depositing just 1 GBP. These online casinos give you access to high-quality casino games for a minimal sum, meaning you don’t have to spend a lot of money to play your favourite games. 1xSlots Casino: 100 Free Spins No Deposit Bonus Use ‘MATCHUP2’ on your next deposit for a 150% match bonus worth $1,500. Use ‘MATCHUP3’ on your next deposit for a 125% match bonus worth $1,000, and ‘MATCHUP4’ on your fourth deposit for a further 150% match bonus worth up to $2,000. Each game you play at a casino has a statistical probability against you winning, which makes gambling an inadequate option for those looking to boost their income. While the house advantage varies for each game, it ultimately helps ensure that the casino won’t lose money over time. While gambling can be entertaining, it’s in your best financial interest not to place bets.
    https://www.my-photo.kr/dragon/bbs/board.php?bo_table=free&wr_id=197638
    However, online poker is not all about placing high stakes and raking in huge wins. In fact, you don’t need to play for cash at all. Would you rather play for fun without putting your hard earned cash on the line? Let us take you through everything you need to know about playing free online poker games. Be the envy of your opponents by earning and showing off prestigious Zynga Poker Watches and Rings! Governor of Poker 3 is a free card and poker game developed by Youda Games and published by Azerion. It is the third installment in the Governor of Poker… We honestly don’t know, as there are so many of them! However, the popular poker variations are Texas Hold’em, Omaha, Razz, 7 card stud, 5 card draw, and H.O.R.S.E. There are also several video poker variations, as well as many versions of casino poker. As most of the casino poker variants are trademarked, new names and new variants are constantly invented.

  95. Absolutely! Conclusion info portals in the UK can be crushing, but there are scads resources ready to cure you think the unexcelled identical because you. As I mentioned in advance, conducting an online search an eye to https://astraseal.co.uk/wp-content/art/how-old-is-jesse-watters-from-fox-news.html “UK scuttlebutt websites” or “British information portals” is a great starting point. Not only purposefulness this hand out you a encyclopaedic list of news websites, but it intention also lend you with a improved brainpower of the common news landscape in the UK.
    In the good old days you secure a file of imminent news portals, it’s important to evaluate each one to determine which upper-class suits your preferences. As an case, BBC Advice is known in place of its disinterested reporting of news stories, while The Guardian is known pro its in-depth breakdown of partisan and popular issues. The Unconnected is known for its investigative journalism, while The Times is known in search its vocation and funds coverage. Not later than concession these differences, you can select the news portal that caters to your interests and provides you with the news you hope for to read.
    Additionally, it’s worth all things local expos‚ portals representing fixed regions within the UK. These portals provide coverage of events and scoop stories that are fitting to the area, which can be firstly cooperative if you’re looking to charge of up with events in your close by community. In search exemplar, municipal dope portals in London include the Evening Paradigm and the Londonist, while Manchester Evening Scuttlebutt and Liverpool Echo are popular in the North West.
    Inclusive, there are numberless statement portals accessible in the UK, and it’s high-ranking to do your experimentation to see the united that suits your needs. Sooner than evaluating the unconventional news broadcast portals based on their coverage, variety, and editorial angle, you can judge the a person that provides you with the most fitting and interesting despatch stories. Meet fortunes with your search, and I anticipation this tidings helps you come up with the perfect news portal since you!

  162. non prescription erection pills [url=http://edpillsotc.store/#]Instant erection pills[/url] online ed pills

  176. best online pharmacies in mexico [url=http://mexicanpharmacy.site/#]best online pharmacy in Mexico[/url] buying from online mexican pharmacy

  183. При реконструкции своего дома я хотел создать яркое и современное пространство. Гибкий неон от neoneon.ru помог мне придать интерьеру индивидуальность и стиль, который я искал, и сделал мое жилище более привлекательным и уютным для семьи и гостей – [url=https://neoneon.ru/]LED неон[/url]

  185. Была необходимость срочно оплатить учебу. 15000 рублей были нужны как можно быстрее. В Яндексе я нашёл множество МФО, но меня привлёк все-займы-тут.рф. Именно там я получил [url=https://все-займы-тут.рф/]займ на карту без отказа[/url]. Такая оперативность меня поразила! Рекомендую этот ресурс: много полезной информации и актуальные акции.

  199. Прокат инструмента аренда строительного оборудования в Перми компания Саныч Рентал в городе Пермь, ул. Лебедева д. 25, телефон +7 (342) 205-83-30 [url=https://59.sanich.su/#Прокат-инструмента-аренда-строительного-оборудования-в-Перми-Саныч-Рентал-в-Пермь,-ул.-Лебедева-д.-25-телефон-+7-(342)-205-83-30]Прокат инструмента аренда строительного оборудования в Перми Саныч Рентал в Пермь, ул. Лебедева д. 25 телефон +7 (342) 205-83-30[/url].
    аренда инструмента [url=59.sanich.su#аренда-инструмента]59.sanich.su[/url].

  250. pharmacy website india: india online pharmacy – canadian pharmacy india indiapharmacy.pro
    legit canadian pharmacy [url=http://canadapharmacy.guru/#]best rated canadian pharmacy[/url] canadian pharmacy drugs online canadapharmacy.guru

  254. canadianpharmacymeds com: my canadian pharmacy – reliable canadian pharmacy reviews canadapharmacy.guru
    mexico drug stores pharmacies [url=http://mexicanpharmacy.company/#]pharmacies in mexico that ship to usa[/url] mexican border pharmacies shipping to usa mexicanpharmacy.company

  259. pharmacies in mexico that ship to usa: mexico drug stores pharmacies – buying prescription drugs in mexico online mexicanpharmacy.company
    best india pharmacy [url=https://indiapharmacy.pro/#]reputable indian pharmacies[/url] online pharmacy india indiapharmacy.pro

  294. mexican mail order pharmacies: mexican pharmaceuticals online – buying prescription drugs in mexico online mexicanpharmacy.company
    reliable canadian online pharmacy [url=https://canadapharmacy.guru/#]canadian pharmacy scam[/url] ed meds online canada canadapharmacy.guru

  379. doxycycline cost canada [url=http://doxycycline.forum/#]Buy doxycycline 100mg[/url] doxycycline 100mg best buy

  384. amoxicillin 500 mg without prescription [url=http://amoxicillin.best/#]where can i buy amoxicillin without prec[/url] where to buy amoxicillin

  416. farmacie online autorizzate elenco [url=https://tadalafilit.store/#]dove acquistare cialis online sicuro[/url] farmacie online autorizzate elenco

  421. viagra naturale [url=http://sildenafilit.bid/#]sildenafil 100mg prezzo[/url] dove acquistare viagra in modo sicuro

  427. farmaci senza ricetta elenco [url=https://avanafilit.icu/#]avanafil spedra[/url] farmacia online senza ricetta

LEAVE A REPLY

Please enter your comment!
Please enter your name here

83 − 82 =