First of all, use decimal (18,4) instead of real. Real is not a precise datatype (as you can see with 0.6 that is represented as .600002).

Second this is gonna be...

Alright. Sorry to ask but do you still need help (not too sure from your last post)?

Now you know why you should ALWAYS post the expected results .

create table tmb1 (deptno numeric, sal numeric)

insert into tmb1 (deptno, sal )...

Eating paste or pasta ??

Yes. You can read more here :

Dynamic Search Conditions in T-SQL

Actually this one worked too.. you just had to execute it from the pubs database.

" select column_name

,data_type

...

Check the string fields. Some data you are trying to insert is too large for the column.

I still know what a pencil is .

Is this the results you need?

create table tmb1 (deptno numeric, sal numeric )

insert into tmb1 (deptno, sal ) values (1, 1000)

insert into tmb1 (deptno, sal ) values (1, 2000)

insert into...

It's a pencil with color used mostly for drawing stuff.

I think you forgot one point. If you have a lot of users that can access the same sets of form. There will be a few 10K of...

He's already enjoying like (beer) instead of posting here .

Why do you think he doesn't post??? It goes really well with the beer .

Yup, happy birthday.

I'm sorry if I got you confused. This is in windows but my version is in french so I tried to get you a translation which was incorrect obviously.

on...