Thank you

Thank you very much, it worked, so just to understand how instr translates in sql?

Example:InStr(1,[last_name]," ")

I am sorry, but this code is incorect is not giving me a right data:

This is what I need:

I have data:

First Name ...

Thank you, what about my second :

I need to convert this:

Right([Field3],(Len([Field3])-InStr(1,[Field3]," "))) & [Field4]

Joe's code:

RIGHT(FIELD3,LEN(LEFT([FIELD3],PATHINDEX(' ',[FIELD3])-1))+[FIELD4]

I did this: --(Field3 =FirstName and Field4 Last Name)

RIGHT (FIRST_NAME, LEN(LEFT (FIRST_NAME, PATINDEX(' ', FIRST_NAME)...

Thank you

Can you showe me how to do it please. Thank you

I am confused, sorry, how can I put it together in the query of the SQL Server. Thank you

Thank you

Also, how can I convert this:Len(Left([Field3],InStr(1,[Field3]," or")-1)) Thank you

Thank you, so

NA: Right([Field6],Len([Field6])-InStr(1,[Field6],"Unit")+1)

is equeal to this

RIGHT([Field6], LEN([Field6]) - CHARINDEX('Unit', [Field6]) + 1)

or this

SUBSTRING([Field6], CHARINDEX('Unit', [Field6]), 100)

right?

Your recomendation to use this:SUBSTRING([Field6], CHARINDEX('Unit', [Field6]), 100) ...

Thank you

Thank you it worked

it is exuciting inside of the querydef

tHANK YOU

around 50. Thank you