I completely agree with you Jeffrey unfortunately that was the requirement and didn't want it no other way only spaces.

ChrisM@Work just read your post that is the absolutely spot on , I didn't think a CASE Statement could achieve what i was looking for so i quickly dismissed it...

[] = Represent spaces

So the vendor can only contain a maximum of 7 numeric values i want a statement which counts the number of numeric values of the vendor lets...

Thanks for your reply Gianluca Sartori

Its not quite but close to the desired results that I'm expecting.

For example if i change 7 to lets say 3, then only 4...

Hi

I came across a previous post i was working through which might be able to help you

http://www.sqlservercentral.com/Forums/Topic263272-8-1.aspx

My mistake wrong post

oh right that can work

Thanks for your help Gianluca Sartori and Phil much appreciated.

OK sorry should of explained in more detail, the reason i asked for a different method for the numeric is because if i wanted to change the number of characters...

is there a different mention instead of using /100 ????

Thanks for your reply I've tested the following code

select LEFT(P.Vendor,6)

, P.Shipto

, P.Weeks

, p.Product

...

Is this what you looking for

CREATE TABLE DiaryEntries(

[ID] [VARCHAR](10) NULL,

EmpId [VARCHAR](10) null,

[date] [VARCHAR] (10)null,

[message][VARCHAR](10) null,

)

DROP TABLE DiaryEntries;

INSERT INTO DiaryEntries

VALUES('1','123','2092001','TEST')

INSERT INTO DiaryEntries

VALUES('1','123','21092001','TEST2')

INSERT INTO DiaryEntries

VALUES('1','123','21092001','TEST')

SELECT * FROM DiaryEntries

select...

I've tried your method of changing the data type in the creation of the table, it returned the results i desired. Thanks for your advice

I'm using a custom built integrator(middle ware) that allows one to move data between disparate data sources but also allows you to manage it as well.

So it works by...

Oh right that clears that up on, the problem is that I'm unsure how to relate that to my script

I'm using a software Notepad ++ and Microsoft standard notepad which...

Thanks for your replies

To be honest i don't understand the script below, this returns 32 for me.

declare @name varchar(256)

set @name = ' 1231'

select ascii(SUBSTRING(@name , 1 , 1))

I cant...