the table has 100 records in it

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle....

The user is the same...there is no error message, it just doesnt update.....

If riding in a plane is flying, then riding in a boat must be swimming. To experience the...

As preethi assumed, I was trimming after concatenation, therefore it wasnt working. Thanks for the help guys.

If riding in a plane is flying, then riding in a boat must be...

Preethi's suggestion worked, cheers Preethi

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

What is it with concatenation!

Not too sure where your heading with this:

Rec_ID Value Concatened_Value

1 first_value 'str1 str2'

2 second_value 'str3 str4 str5'

What exactly are you...

Actually, one point which may be of interest......previous to today this wasnt a problem, the cust_id field appeared as one long concatanated string with no spaces. the code hasnt been...

Yeah, cust_id is large enough without a doubt. the casting doesnt seem to hav an effect

If riding in a plane is flying, then riding in a boat must be swimming....

See first post! Thats all there is too it, the problem must lie in there somewhere.....

update clnpers set cust_id = shop_id + rec_sname + rec_fname + rec_bday;

If riding in a...

I can see what the function does by your example, but as far as I can see it returns an obvious answer, I dont think it will solve my problem......

your...

Have tried this......DATALENGTH only return the length that I have set when formatting the fields which can of course be viewed in design view............

Thanks for the idea though!

If riding in...

Ok..tried LTRIM and RTRIM but no joy.still the same result

I haev a hunch the problem doesnt lie withinthe size of the fields themselves..what do you think?

If riding in a plane...

I see...........well the reason for using char is that Im on the way to using Business Objects and it doesnt seem to like varchar. Ill give the TRIM functions a...

Hmmm, wasnt aware of a LTRIM and RTRIM function in SQL..whats the syntax for that?

cust_id is of type char also

If riding in a plane is flying, then riding in a...

where are you transfering from?

If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

I had this same problem a while back....somewhere in the log in settings theres an option that says something like

"Use a trusted connection"....I think Ian is right though......use windows...