If I use Trim(Nz([Service State],""))
as the Update To value in an update query then:

If the value of [Service State] = "Ca " then it will return "Ca"
or if the value of [Service State] is null then it will return a zls.. right?

Am I correct to assume this?

yes, that is correct.