# SQL Server Msg 8114: Error converting data type varchar to numeric

**Code:** `8114` · **Category:** SQL · **Seen on:** SQL Server, SQL

A text value that isn't a valid number was converted to DECIMAL/NUMERIC.

## Meaning

Find bad rows with `TRY_CONVERT` / `ISNUMERIC` (careful: `ISNUMERIC` accepts '$' and ','), strip formatting, and fix the data load. Culture-specific decimals (`1,5`) are a common cause.

## Common causes

- Non-numeric text (empty string, 'N/A')
- Thousands separator or currency symbol
- Decimal comma
- Precision/scale too small for the value
- Implicit conversion in a join

## Quick fix

1. Locate rows: `WHERE TRY_CONVERT(decimal(18,2), col) IS NULL AND col IS NOT NULL`
2. Clean the data before converting
3. Use `TRY_CAST` for tolerant conversions

## Detailed fix by platform

### SQL

1. `SELECT col FROM t WHERE TRY_CONVERT(decimal(18,2), col) IS NULL AND col IS NOT NULL;`

## How to diagnose

1. **Bad rows** — Found?
2. **Separators** — Present?
3. **Precision** — Enough?

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/mssql-error-converting-varchar-to-numeric-8114)
