Ray's suggestion should work for you. But using CONVERT and SUBSTRING, you would do this:

SELECT

SUBSTRING((CONVERT(CHAR(11),Fieldname)),9,2)

FROM tablename

The (CONVERT(CHAR(11), FieldName)) replaces the value that you want to 'substring'.

-SQLBill

Here is a real basic reason....in Simple mode when a transaction is commited (written to the database), the log is CHECKPOINTed. That basically tells the database that 'this data no...

Best practice is to put your TEMPDB on a separate drive and put your logs on another separate drive. Notice I said separate drive, putting them on a separate...

All,

The poster continued this in another thread instead of keeping it all in one thread.

The continuation is here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=264565

-SQLBill

Ritesh,

You should have continued this in your original thread.

This is a continuation from:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=264425

-SQLBill

Your error message refers to "Microsoft JET Database Engine". JET is normally Microsoft Access.

This site, while it does have a forum for Access, is for Microsoft's SQL Server. SQL Server...

You just had to take unexpected timeoff and will be off work for over a month. The company brought me in to fill-in for while you are gone.

How the heck...

Could it be special characters? Like the tilde being in one name but not the other. Or an apostrophe?

O'Donnell and ODonnell

Padre` and Padre

-SQLBill

There could be extra space(s) between the first and last name.

In SQL Server, try using the LEN command to find the length of the name. Then compare that to the...

There is a solution. It's called COPYWRITE. If your database, etc. is unique, then you should be able to copywrite it. You could also have the company sign a...

On the remote system, did you create the database? Are you the administrator? As the error said...you need to use the SA login, be a member of SQL Server sysadmin...

You need to use the WITH NORECOVERY option on each restore but the last. Basically, you restored one file and told SQL Server to stop here, when there were...

Add this to the beginning of your script:

SET DATEFORMAT MDY

The issue is that SQL Server doesn't know if 3/15/06 means March 15, 2006 or the 3rd day of the 15th...

If you had a backup, you would be able to restore from the backup file.

Looks like you are out of luck. Somehow your files got corrupted and are unusable....

Please post in an appropriate forum...the "Question of the Day" forum is specifically for responding to the Question of the Day quiz.

-SQLBill