Hi Sean,

The first query worked perfect.

which gave me result

0000567K AS 56.710000

-0000904J as -90.420000

I need only 2 digits to the right of decimal

which would be

56.71

90.42

Thank a lot.

I am a starter and Thank you for the help.It worked perfectly.And how can I get rid of those zeroes at the end

Hi This is a Bi weekly import.But I dont know how to do in Data integrator.Can you please explain how can I do it.The person who knows DI has resigned...

Thank you Sean I will try this and see.I appreciate your help.

Thank you for the reply. I have imported the data from a text file to a table through business objects Data integrator .now I need to write a stored...

Crystal is not case sensitive.I checked with my manager as he is the one who does reporting.

We use crystal reporting to genarate report

I checked if it is case-sensitive collation but it not

Jason thats what I am using for now but my Manager is so picky she wants to find what is causing it.

Sorry for not giving more details.Hope this will help you to help me what I am looking for.Thank you.

CREATE TABLE

#mytable

(

...

Thank you so much and I really appreciate your reply.It worked perfect.Thanks a lot once again for each one of you.

Thank you very much.worked perfectly and Really once again thanks a lot.

Thank you and I really appreciate your reply.I will try and let you know.

thanks once again.

Thank you for the quick reply.I am really new to this and would you mind showing an example.