First, thanks for all your help! You really make a difference, and I GREATLY appreciate it.

So I have a Varchar column and it holds a 16 digit number, example: 1000550152872026

```
select *
FROM Orders 
where isnumeric([ord_no]) = 0

```

> 
> returns: 0 rows
> 
> 
> 

---

```
select cast([ord_no] as bigint)
FROM Progression_PreCall_Orders o
order by [ord_no]

```

> 
> returns: Error converting data type varchar to bigint.
> 
> 
> 

How do I get this 16 digit number into a math datatype so I can add and subtract another column from it? 

UPDATE: Found scientific notation stored as varchar ex: 1.00054E+15

How do I convert that back into a number then?