Search results for query: *

This is as simple as it gets. All fields are varchar but it still won't trim them down ?? SELECT RTRIM(LTRIM(customer.custname)), RTRIM(LTRIM(customer.custcode)), RTRIM(LTRIM(customer.job)) FROM customer

The select statement works, it's not the criteria that is the problem. It just won't trim down the fields and get rid of the spaces. I'm in the UK so at home now, but I'll post the select statement up tomorrow.

When I open up the text file they are definately spaces, not tabs I'm afraid.

I have a stored procedure the last part of which has a select statement. I am running an isql batch file to extract the results to a csv file. For some reason when I select on the varchar fields using RTRIM(LTRIM(field.name)), I still get all the leading or trailing spaces. Is there something...

If the data source is a SQL Server database, does the clinet PC running Crystal always have to have SQl Server client installed. I'm confused because I got the impression specific dll's were adequate. We really don't want the users to have SQL client on their machines if we can get away with it...

Thanks a lot guys your input has solved my problems

I have a database with two specific fields, datereceived and type (T)or (P). I want to count all records received between two dates, which are set as parameters, but only show records of type T in the report. I have tried using a formula to count the number of records between the two dates using...

I find it's easier to get the records from the detail and then sort/group/filter by the primary record field.