Update Query Help

[Alexieoo]

Hello,

I am trying to update a field with commas and spaces in it "German, Shepherd" in an update query. My issue is, when I put "Like German"","" Shepherd*" into the criteria and I go to Datasheet view to ensure I am updating the correct field, and it shows up blank. I have also tried "German & "" , "" & Shepherd". Any comments?



Thanks

[ItsMe]

Maybe
LIKE 'German,*'

or

WHERE ((([MyField] LIKE 'German,')) OR ([MyField] LIKE '*Shepherd'))

[NTC]

rather than guess - look at your data and copy that 1 field, then go to design view and paste that into the criteria......

[Alexieoo]

You way seemed to work. Thank you for your feedback and to"ItsMe". Perhaps I was spelling the string incorrectly... Oh well.