Ah sorry

wot is 'Eye dialect for what. Chiefly British.' Now don't ask me what 'Eye dialect' means

What does what mean?

You're confused!!!

I like statistics Especially those I have manipulated myself

Wot your age

CREATE  FUNCTION dbo.test (@inputstring varchar(255))

RETURNS varchar(255)

AS

BEGIN

DECLARE @outputstring varchar(255)

SET @outputstring = @inputstring

DECLARE @pos int

SET @pos = PATINDEX('%[^0-9A-Z]%',@outputstring)

WHILE (@pos > 0)

BEGIN

SET @outputstring...

Or

SELECT * FROM CLIENTGROUP 

WHERE CHARINDEX(''''+FK_CLIENTID+'''',@X) > 0

nb this will do a scan and not a seek like the IN operator does so check performance

Actually my aim is to provide a search facility for our Web Server.

That is why I do it....

As McCork states if you have full recovery activated then

backup current log

backup full database (just in case)

restore database from previous backup (last day backup)

roll forward log

Use a temp table and a loop

CREATE TABLE #temp(....)

DECLARE @startpos int,@endpos int

SET @startpos = 1

WHILE (@startpos < LEN(@UnitID))

BEGIN

    SET @endpos = CHARINDEX(',',@UnitID+',',@startpos)

    INSERT INTO...

What I do

1. Use Acrobat (min v5) to save the PDF in RTF format

2. Use Word op open RTF file

3. Copy text and store in database

I do 1 manually and use...

My wife has some very efficient methods to bring me back to reality

I know what you mean and...

Language barrier! burn that midnight oil ???

Careful you don't break your arm patting yourself on the back

Great explanation Thomas

This is one of my favourite mistakes and now is the first thing I look for in duplicate results

Bah phoey Frank! But hey you do burn that midnight oil eh Glad my PC has...

Modest as ever Frank.

CAST(REPLACE(qtyavail,',','') as numeric(9,2)) + CAST(REPLACE(qtyavail and qtyatbranchavail) as numeric(9,2))