Recent content by chewy

Kodo, what part of Syracuse do you live in?

didn't work. any other ideas?:confused:

i shall try thanks

good idea thanks

I moved into SQL Server DB myself

I have a table in an SQL database. The field data is in the format "12/29/2003 1:00:00 PM" I cannot change that! I was wondering how to run a query that will change all the dates with "12/29/2003" irregardless what the time was. I have this UPDATE POSTransHist SET POSTransHist.DateTime =...

youll be back. You can not escape this forum!

I need to uninstall MSDE for a program to install it. When I uninstall it and reinstall the software it give me an error every time that it cant find the path c:\program files\microsoft SQL Server\data\osql.exe or similar to this. It use the uninstall in the add remove programs, and I delete...

well judging by the fact that you give us the example of you using Kazaa could be some sort of corruption or virus or something.

do they do these seminars on other days other than Tuesdays and Thursdays? It's kind of hard to leave work to go to this.

Here is what I ended up using: UPDATE Customers SET Customers.Phone = (mid(Customers.Phone,2,14)) WHERE ((left(Customers.Phone,1) = '1')) I forgot I actually was writing to a temporary Access Db before importing into SQL Server Thanks for everyones help!

Thank! I'll shall try tomorrow

Mid is not a recognized Access statement. Does anyone know what the SQL Server equivelant would be? The phone number should look like this: "(555) 555-5555"

this is not Access it is SQL Server. Will that make a difference?

I have a sql statement. It is a phone number field. I want to if there is a 1 infront of the phone number to take it out. The phone would look like this: 1 (315) 344-3312 The statement I am using is this: UPDATE Customers SET Customers.Phone =...