LIKE WITH * value * on join

[sal21]

Code: Select all

... ON TAB.DENOM LIKE * TAB1.NOMINATIVO *

i need to use a like on a entire filed TAB1.NOMINATIVO... similar * TAB1.NOMINATIVO *

is this correct?

note:
i need to use in Access Ide

[HansV]

Try

Code: Select all

... ON TAB.DENOM LIKE '*' & TAB1.NOMINATIVO & '*'

[sal21]

Try

Code: Select all

... ON TAB.DENOM LIKE '*' & TAB1.NOMINATIVO & '*'

OK TKS!

2 qstions:
1)
is the same to use the like statement TAB.DENOM similar:
2)
the like statement match:

sal oppppp and opppp
sal opppppppp and opp



ops, correct now?
]... ON 'like *' & TAB.DENOM & '* = TAB1.NOMINATIVO

[HansV]

1) Wildcards * and/or ? work only with LIKE, not with =.

2) Yes.

[sal21]

1) Wildcards * and/or ? work only with LIKE, not with =.

2) Yes.

my result whith your code return nothing!!!!!

in effect i need to mach:

tab1 tab2
mario rossi > rossi mario
bianchi mario > mario bianchi
bianchi > bianc

is correct your attement to match the value in example?

[HansV]

You can't match "mario rossi" with "rossi mario" using = or Like. You'll have to 'clean' the data so that they are all in a consistent format, either "firstname lastname", or "lastname firstname", but not a mixture of both. Even better would be to store first name in one field and last name in another field.

[sal21]

You can't match "mario rossi" with "rossi mario" using = or Like. You'll have to 'clean' the data so that they are all in a consistent format, either "firstname lastname", or "lastname firstname", but not a mixture of both. Even better would be to store first name in one field and last name in another field.

Instr in field help me?

Hummmm i cannot store in sepsrate field name and last nname i dont know the sequence in single field. I csn have in a field name an last name and in other field a mix....

[HansV]

There's no easy solution for your problem.

[sal21]

There's no easy solution for your problem.

Peraph firts steep...

...
Dim ShowInfo() As String
TEST = RS1.Fields(0).Value
ShowInfo = Split(TEST, " ")
...

only a prob.

the string in TEST have a variable block o sub string:

similar:

AAAA BBBB
DDD BBB GGG

how to loop with ubound count ShowInfo?

and return:

BBBB AAAA
GGG BBB DDD

in effect TEST is Lastname and name

and i need

Nmae Lastname

[HansV]

How many records do you need to process?

[sal21]

How many records do you need to process?

APPROX 100

[HansV]

OK, that's manageable. Try this:

Code: Select all

    Dim ShowInfo() As String
    TEST = RS1.Fields(0).Value
    ShowInfo = Split(TEST, " ")
    Select Case UBound(ShowInfo)
        Case 1 ' 2 parts
            TEST = ShowInfo(1) & " " & ShowInfo(0)
        Case 2 ' 3 parts
            TEST = ShowInfo(2) & " " & ShowInfo(1) & " " & ShowInfo(0)
        Case Else ' 1 part or more than 3
            ' Leave alone
    End Select

[sal21]

OK, that's manageable. Try this:

Code: Select all

    Dim ShowInfo() As String
    TEST = RS1.Fields(0).Value
    ShowInfo = Split(TEST, " ")
    Select Case UBound(ShowInfo)
        Case 1 ' 2 parts
            TEST = ShowInfo(1) & " " & ShowInfo(0)
        Case 2 ' 3 parts
            TEST = ShowInfo(2) & " " & ShowInfo(1) & " " & ShowInfo(0)
        Case Else ' 1 part or more than 3
            ' Leave alone
    End Select

as usual you read n my "mind"!
Perfect.