Search results

Thanks, I just mistakenly used char(50) instead of varchar(50) and noticed that blank character spacers (amounting to 50) were being inserted. All fixed now, thanks for the help.

thanks for the speedy reply, can you just confirm that basically it's necessary to use the trim statement all the time to avoid the trailing space? Thanks.

What data type should I use if I have no idea how much data will be entered? And is there anyway of avoiding all the trailing white space if I enter, e.g. varchar(50). Thanks in advance.

Ok, thanks!

Hi, is there any way to do an order by, but specify that a particular value is listed last, or first. E.g. ORDER BY t_name ASC ... but feature Simon first and not with the other names beginning with 'S' Thanks.

great, thanks!!

Hi, is there anyway to perform a query and have it order by the count? I thought it was possible but keep getting an error. I'm using the following: SELECT st_term, COUNT(st_term) AS QueryCount FROM tblSearchTerms GROUP BY st_term ORDER BY QueryCount Any help would be *hugely* appreciated...

Thanks Uncle Gizmo, yes this is the result of a seriously overlooked factor, in an ideal world, I would have designed the database differently, but have learned a life long lesson. All tables are exactly the same structure, just named differently. Thanks very much indeed for your advice any...

Sorry, I should have been more specific, I actually need to keep the existing tables with the existing data, duplicate it, change the column names in the duplicated table and then merge the new table with the new column names into the old table with the old table names!

Hi, I have a db (MS Access 2000) that currently has 37 tables in it, each table holds about 30 rows and 72 columns of data. I need to basically create the entire database again but change all the column names slightly so that they still hold the same information but with different column names...

thanks Wayne, yeah it's the same as the one in the SQL forum.

sorry, no I'm not sure. I was hoping it would be Access because I have no experience with any other database software. If it is SQL server is there anyway I can tell? :confused:

thanks, I just tried that and it said "unrecognised database format" for both .mdb and .mde. Does that mean it's not either of those? The reason I don't think I can get an answer from the old company is because my client had a falling out with them and they've already been difficult sending...

Hi, I've recently taken on a new client with exisitng sites running off one database and I need to move the sites to a new server, including the database. The old company that the client was using have provided me with the site files and the database as a .bak file. I am a total newbie with...