This question already has an answer here:
I'm trying to look into what kind of encryption I can do with SQL server standard edition from 2008 and later.
So far, I know that I can't use Transparent Data Encryption (TDE) as that's part of Extensible Key Management (EKM).
When I look up this topic I'm getting the result that column encryption is possible, but then I also find that cell level encryption is sometimes referred to as the same thing and that it is also part of EKM.
These are the sources from which I'm getting the contradictory information:
Any clarity on this subject would be very helpful.