Dynamic execution method (release/debug mode)

I understand that a VB app may be compiled 2 ways (ie.,Release,Debug). Generally, we would like to use release version in production but there are times when I need to use the debug mode. I do not want to maintain two versions of exe. My application reads off data from a SQL Table so I'm thinking of leveraging that for an IF... Else statement. However, I need to know if it is possible to include the execution mode into the VB script rather than rely on the compile method. Is that possible

Thanks.