Query Where Clause

Question

looking to to take the values from a textblock and run that through a query....
But I am looking to make sure its a wildcard search...

Questions:
query.OutFields.Add("*") - Does this give the query parameters to search these fields?

Something like this were its:
returning all fields so I can populate a listbox
Grabing the value from the FindAddress Textblock
Look in [Address] Field Where LIKE value from FindAddress Textblock

Think I just need a syntax check on the WHERE clause??

Thouhts
        Dim query As New ESRI.ArcGIS.Client.Tasks.Query()
        query.OutFields.Add("*")
        query.Text = FindAddress.Text
        query.Where = [Address] Like FindAddress.Text
        query.ReturnGeometry = True
        query.OutSpatialReference = MyMap.SpatialReference
        queryTask.ExecuteAsync(query)

JayKappy · Answer

Absolutly Fantastic....Thank you very much Ali...I was trying that above in my first post but did not have the syntaqx nearly correct...

Very appreciated.

AliMirzabeigi · Answer

Jay,
 
I suggest you to use the LIKE operator while querying string values. The following code snippet looks for all rows that contain the trimmed string in your FindAddress TextBox control:
 
query.Where = string.Format("Address LIKE '%{0}%'", FindAddress.Text.Trim());

JayKappy · Answer

Seems like I have answered a couple of my questions....
Seems the below will search and return partial values on the Field PID.
So it appears that it is automatically doing a wildcard search        Dim query As New ESRI.ArcGIS.Client.Tasks.Query()
        query.OutFields.Add("PID")
        query.Text = FindAddress.Text
        query.ReturnGeometry = True
        query.OutSpatialReference = MyMap.SpatialReference
        queryTask.ExecuteAsync(query)

Last thing...why cant I find a string field with spaces?  I verified that the value exists in the data and that the spelling was correct.
Still cant find it....Something to do with the Spaces???

7707 SMITH AVE N

Any thoughts