Ok it work

now The big problem How can i do this ?

---------------------

            fld1                      fld2                      fld3                   fld4

1. aaaaaaaaaaaa     bbbbbbbbbbbbb       cccccccccccccccc     ddd
2. aaaaaaaaaaaa     bbbbbbbbbbbbb       cccccccccccccccc     dddd

can someone  help

and show how to do it on my problematic Table

at the moment the All the Records is in One Table in One Field

thnks a loot

 ilan

but how can i do this  ???

-------------------------------------------------

1     INIT/A1AH105, AI, 1.0, IV =  LATCHED, FM =     2, DG =      0, TB =    20, BB =     0, 

2                        ED = '            aabbccdd',...

this is my table

any solution ????

this is my table

an like this i have 800000 records

-----------------

INIT/A1AH105, AI, 1.0, IV =  LATCHED, FM =     2, DG =      0, TB =    20, BB =     0, 

                        ED...

i found the problem !!!!!

it is in the function !!!!

when i do this

-----------------------

declare @strin varchar(5000)

set @strin = 'xxxxxxxxxxxxxxxxx'

select dbo.fn_reverse(@strin)

------------------------------

i get NULL value

OR THIS

--------------------------

declare @strin varchar(5000)

set @strin =...

How can I do this???

I wont to use this function like this!!!

 Loop every single record and insert it to a new table

I wont to check every record one after one

So...

hi

i dont understanding what appen

when i put the function on this

------------------

declare @strin varchar(1000)

set @strin = 'noitcennoc tenr[et]ni na htiw 1234-ABCD "g\nihtyna +,,tuoba HIJK-5678'

select dbo.fn_reverse(@strin)

--------------------------------

it work ok

but when i do this

----------------------

SELECT    ...

WOW it work ok

thnks thnks thnks ..............

----------

litele problem

the the Caps are REVERSE can you fix it ???

thnks for all

ilan

can you hlep last time ?

for clean Strip the field   before i run the function

 and remove all this

 the (garbage) from the field !!

-----------------------

this Symbols

{}][\...

thnks men

it work but

if between the words i have this

)( , \; ' / \ .

it cut  it and i get only part of the words

so  how ...

thnks but i get a error

-----------------

Server: Msg 536, Level 16, State 3, Line 1

Invalid length parameter passed to the substring function

----------------------------------

did it

clean all the (garbage)  and the character [" "...

WOW genius brilliant

ok

need help

problem 1

how can i loop the select

---------------------------------

SELECT     TAGNAME, TAGDESC, EUDESC

FROM         tbtxt

-----------------------------------------

my problem with the field "TAGDESC" this field is the  "REVERSE "

thnks

problem 1

the code get error

----------------------------------------

Server: Msg 208, Level 16, State 1, Line 3

Invalid object name 'dbo.split'.

---------------------------------------------------

problem 2

how can i loop this sql code in this field

i...

like this

"noitcennoc tenretni na htiw 1234-ABCD gnihtyna tuoba HIJK-5678"

i need to revers all and

not the "1234-ABCD " AND NOT THE "HIJK-5678"

so  after i revers it i...