They can't alter the stored procedure but they can request changes to the report.  

That is very true but in this case I had to use * to collect all the fields from the database and insert them into crystal report. The fields used are...

The query I asked about was fairly simple and i didnt think details of the table would be necessary because I needed all the information from the table and looking at...

Thank you Carl!

select *

, convert(varchar,convert(datetime,Date_Lst_Iss),103) as UKdate

from dbo.Part_Mast

where Part_Num LIKE (RTRIM('258095GB') + '%')

order by Part_Num

This query actually provides me with the correct results i was looking for. Thank...

select * into #temp from

(select convert(varchar,convert(datetime,Date_Lst_Iss),103), Part_Num from dbo.Part_Mast

where Part_Num LIKE (RTRIM('258095GB') + '%'))

Server: Msg 170, Level 15, State 1, Line 3

Line 3: Incorrect syntax near ')'.

even when  I run the first query first i get a bracket error where as they are no extra brackets also im running both the queries in a stored proceudre...

select * into #temp from

(select convert(varchar,convert(datetime,Date_Lst_Iss),103), Part_Num from dbo.Part_Mast

where Part_Num LIKE (RTRIM('258095GB') + '%'))

select * from dbo.Part_Mast

where Part_Num in (select Part_Num from...

yes but what about the date?

Hi,

But I need that query, thats the query im trying to add to the orginal sql query. I'm trying to make it work with that query.

any suggestions

Thanx

Thank you very much for your replies

I dont quite understand this error when i run the above query i get the following error.

Server: Msg 457, Level 16, State 1, Line 13

Implicit conversion of varchar value to...