If first 3 decimals of my number are 0 and number starts with 0, then number = 0:

Example: 

n=0.0005677=> n= 0(0.00)

n=0.000055664=> n= 0(0.00)

**Edit 1:**

Here is a sample:

```
WHERE   ((cc.ID = @ID) OR (@ID IS NULL))
    AND ((cc.carTypeID = @CarTypeID) OR (@CarTypeID IS NULL))
    AND cc.active = 1
    AND lp.Latitude != 0 AND lp.Longitude != 0

```

Line 4 : So in this stored procedure it will not display the rows where latitude=0 and longitude =0 , i want to achieve the same thing when lat and longitude are for example 0.000455 or 0.0000555.

P.S.: Hope this makes it clear and sorry for the poor info when I first posted. Thanks all for your answers. 

**Edit 2:**

What do you think about this approach? :

```
WHERE   ((cc.ID = @ID) OR (@ID IS NULL))
    AND ((cc.carTypeID = @CarTypeID) OR (@CarTypeID IS NULL))
    AND cc.active = 1
    AND CONVERT(NUMERIC(6, 3), lp.Latitude) !=0 AND CONVERT(NUMERIC(6, 3), lp.Longitude)  !=0 

```

This function looks like is working as expected and can be used as a more general approach.

Do you know any downside or why I should I not use it?