<div>
Worked like a charm. <br />
<br />
Thanks!!
</div>


<div>
<div class="content wysiwyg-content">
Need help with the REPLACE command. After running this SELECT :<br />
<br />
SELECT &nbsp; &nbsp; CATEGORY, QTY_STK, ACTIVE<br />
FROM &nbsp; &nbsp; &nbsp; &nbsp; ITEMS<br />
WHERE &nbsp; &nbsp; (CATEGORY = '166') AND (QTY_STK = 0) AND (ACTIVE = 'T')<br />
<br />
I need to replace the ACTIVE='T' with ACTIVE='F' , what would the syntax be?
</div>
</div>


Need help with the REPLACE command. After running this SELECT :

SELECT     CATEGORY, QTY_STK, ACTIVE
FROM         ITEMS
WHERE     (CATEGORY = '166') AND (QTY_STK = 0) AND (ACTIVE = 'T')

I need to replace the ACTIVE='T' with ACTIVE='F' , what would the syntax be?

SELECT, FROM, WHERE, REPLACE COMMANDS

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Operating Systems

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.