does my solution not work???

I'll test it with a million rows and see what happens...

OH and you haven't given us an example of a different start position?

Here is a solution that doesn't use a loop.

It uses a tally table.

The only thing missing from the query is that I'm not 100% sure how the StartPostion comes into...

at least you not getting an error now.

So all that needs to be is to make sure your data is correct that you searching for 🙂

Sorry was thinking of something else.

If you change the EXEC @sql to :

EXEC (@SQL)

It should work

cool I'll wait for your reply.

It might also be funny data in your table.

but I can't see any columns being used for the dynamic build...

cool please could you post the full CREATE PROCEDURE code.

Sorry to be a pain, but something is missing here...

where is the code that sets the variables and declares the variables???

I need a script I can copy directly from here and paste into a SSMS window and run to...

Ok.

But you still haven't post the exact script that you are running...

We can't help if we don't know the values of the variables

nah it's cool I been editing my posts 🙂

mmm you basically just wrapping you " in Quotes but it seems wierd cause there are 4 of them I know.

Sorry I'm not 100% sure how to explain this...

But basically...

oh sorry about that.

try this

select left([name], 1) from table1 where left([name], 1) ="""" and right([name], 1) =""""

both of the posting that I have made run 100% and the only thing I have changed was adding the )

So I think the actually variable values that are being...

what about if you run this?

CREATE TABLE InsSales

(

region VARCHAR(100),

SaleYear INT,

salesPerson VARCHAR(100),

SalesMonth INT,

TotalSales INT )

GO

DECLARE @CYear VARCHAR(100)

DECLARE @PYear VARCHAR(100)

DECLARE @SalesPerson VARCHAR(100)

DECLARE @Salesmonth VARCHAR(100)

SELECT

@CYear = 2009,

@PYear = 2008,

@SalesPerson = 'Smith',

@Salesmonth =...

🙂

Thanks

You need to use single quotes around the double quotes

DECLARE @table1 TABLE

([name] VARCHAR(100))

INSERT INTO @table1

SELECT '"STICHTING WERELDHULP-BELGIE"'

select left([name], 1) from @table1 where left([name], 1) ='"' and right([name], 1) ='"'

running this code gives no errors.

CREATE TABLE InsSales

(

region VARCHAR(100),

SaleYear INT,

salesPerson VARCHAR(100),

SalesMonth INT,

TotalSales INT )

SELECT x.SaleYear, x.TotalSales

FROM (SELECT SaleYear,

TotalSales =...