Where clause in Database view

[BharatiK]

Hi,

I have created a database view where I have to combine the ABC Table 'name' field (ABC@ddzwinf37) and server table 'name' field (ddzwinf37). 

I need some help with where clause, where we can show the details for ABC table based on server table. 

Thank you.

[Ankur Bawiskar]

@BharatiK 

how are you joining both the tables? share that screenshot

what's the common field?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[BharatiK]

Hi @Ankur Bawiskar ,

There is no exact common field, but the field contains the server's name.

I want to join Name field on ABC table with windows server name field. 

ABC Table: Name field

Server Table: Name field

Thanks.

[Bert_c1]

Doesn't seem possible, as a where clause doesn't support SQL: "LIKE" or "CONTAINS".

AddATableToTheDatabaseView

[Ankur Bawiskar]

@BharatiK 

you cannot search using contains operator in where clause

If my response helped please mark it correct and close the thread so that it benefits future readers.